Re: MDB will no longer accept reuslts

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dave (davekstl_at_charter.net)
Date: 07/13/04 

Date: Tue, 13 Jul 2004 12:58:11 -0500

If I have to Recalc the Web via IIS, does that indicate corrupted
extensions?

Dave

"Jim Buyens" <news@interlacken.com> wrote in message
news:36a7e008.0407122049.926bbf1@posting.google.com...
> 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
    ... Dave ... "Jim Buyens" wrote in message ... I'm not really sure if this setting compresses the database ... > may be forcing a compress every time a Web page runs. ...
    (microsoft.public.frontpage.client)
  • 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: filling in missing dates in a time series
    ... timestep we store ... In practice the restrictions have no adverse effect on the applicability of his relational algebra for database purposes. ... As I understand it, Codd was talking about recording facts through what are called their extensions, basically the enumerations of sets, possibly very lengthy enumerations as you seem to be referring to. ... Wistfully, I find this a bit unfortunate, but maybe I just don't know enough to see that an RM with intensions is a bigger problem, eg., a 'table' defined via intension. ...
    (comp.databases.theory)
  • Re: FP without FP extensions- what do I lose?
    ... it is only for a site that does *not* use FP server ... extensions or any of the components that are required to use extensions. ... Microsoft MVP - FrontPage ... |>> can't make an editable database? ...
    (microsoft.public.frontpage.extensions.windowsnt)
  • Re: KirbyBase
    ... I'm an Object Guy and Jamey is a Database Guy. ... That requires the table name and key field name to be specified ... I suppose it would in effect be embedding an array where all the ... that is) might compress by a factor of 10 or more. ...
    (comp.lang.ruby)