Re: MDB will no longer accept reuslts

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jim Buyens (news_at_interlacken.com)
Date: 07/13/04 

Date: 12 Jul 2004 21:49:21 -0700

Well, I'm not really sure if this setting compresses the database
every time *anything* closes it, or just every time the Microsoft
Access desktop program closes it.

If the compress occurs whenever *anything* closes the database, you
may be forcing a compress every time a Web page runs. This could be
dozens of times a second. And each compress locks the database for
exclusive control, creates a new .mdb file, then deletes the original
.mdb file, then renames the new one. With all that going on, I could
believe the server extensions might lose track of the database
connection.

It's worth a try.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

"Dave" <davekstl@charter.net> wrote in message news:<10f5tsdehahav4b@corp.supernews.com>...
> I went into MDB, Tools/Options/General/checked Compact on Close.
>
> Could this the issue?
>
> Dave
>
> "Jim Buyens" <news@interlacken.com> wrote in message
> news:2ad7901c4684f$397af100$a601280a@phx.gbl...
> > How did you set the MDB set to compress upon closing?
> >
> > Have you tried running with tht option turned off?
> >
> > Jim Buyens
> > Microsoft FrontPage MVP
> > http://www.interlacken.com
> > Author of:
> > *----------------------------------------------------
> > |\---------------------------------------------------
> > || Microsoft Office FrontPage 2003 Inside Out
> > ||---------------------------------------------------
> > || Web Database Development Step by Step .NET Edition
> > || Microsoft FrontPage Version 2002 Inside Out
> > || Faster Smarter Beginning Programming
> > || (All from Microsoft Press)
> > |/---------------------------------------------------
> > *----------------------------------------------------
> >
> >
> >
> >
> >
> > >-----Original Message-----
> > >I have a asp page feeding a MS ACCESS DB on a local
> machine using IIS on
> > >Win2000Pro. It has been working fine.
> > >
> > >However, sometimes after I open the MDB, new form data
> will no longer be
> > >entered into database. There is no error message, just
> missing data.
> > >
> > >The only way to get the database to update successfully
> again is to run
> > >Recalculate Web via IIS.
> > >
> > >I have the MDB set to compress upon closing.
> > >
> > >Is there something I am missing in that I have to
> repeatly run Recalculate
> > >Web in order to restore the database connection.
> > >
> > >Thanks in advance
> > >
> > >Dave K
> > >
> > >
> > >.
> > >

Relevant Pages

  • Re: MDB will no longer accept reuslts
    ... Microsoft MVP ... "Dave" wrote in message ... >> If the compress occurs whenever *anything* closes the database, ... >> may be forcing a compress every time a Web page runs. ...
    (microsoft.public.frontpage.client)
  • re: FP 2003 failure to post
    ... security changes Microsoft made to the Database Results ... Wizard. ... Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.client)
  • Re: Web Page Search Form
    ... program code that runs on server. ... database information as HTML. ... On a Microsoft Web server, ... Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.client)
  • re: fp2003 database editor error
    ... Are you browsing the page from a Microsoft Web server, ... Does the Web server have the .NET Framework installed? ... Microsoft FrontPage MVP ... >i am building a database application with Fp2003. ...
    (microsoft.public.frontpage.client)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)