Re: MDB will no longer accept reuslts
From: Jim Buyens (news_at_interlacken.com)
Date: 07/13/04
- Next message: JDR: "RE: Creating Pull-Down Menues"
- Previous message: webwranglertx: "Re: FrontPage 2003 FTP Problems"
- In reply to: Dave: "Re: MDB will no longer accept reuslts"
- Next in thread: Dave: "Re: MDB will no longer accept reuslts"
- Reply: Dave: "Re: MDB will no longer accept reuslts"
- Reply: Dave: "Re: MDB will no longer accept reuslts"
- Messages sorted by: [ date ] [ thread ]
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
> > >
> > >
> > >.
> > >
- Next message: JDR: "RE: Creating Pull-Down Menues"
- Previous message: webwranglertx: "Re: FrontPage 2003 FTP Problems"
- In reply to: Dave: "Re: MDB will no longer accept reuslts"
- Next in thread: Dave: "Re: MDB will no longer accept reuslts"
- Reply: Dave: "Re: MDB will no longer accept reuslts"
- Reply: Dave: "Re: MDB will no longer accept reuslts"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
