Access database suddenly crashes?

From: Dean J. Garrett (deanj_garrett_at_yahoo.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 10:52:00 -0800

We've had a small Access database driving a website using ASP code for a
couple of years now. About 2 months ago, the code would intermittantly get
database access errors like the one below. It doesn't always happen, in fact
it can go for days without happening. When this started, the Access database
was Access 97, but since then we've upgraded to Access 2003, but it still
happens. To cure, we do an IISRESET and it fixes the situation for a while.
The only thing that's changed is we caught up on a bunch of Windows Updates
for the Windows 2000 Server OS on the server. Does anyone have an idea of
what to try next?

Thank you!

-----------------
Technical Information (for support personnel)

Error Type:
Microsoft VBScript runtime (0x800A01FB)
An exception occurred: 'Open'
/MemberJoin.asp, line 36

Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows 98)

Page:
POST 207 bytes to /MemberJoin.asp

POST Data:
F_YourCity=&F_YourState=&F_YourCountry=&F_YourZipcode=&F_OtherIndustry=&F_Oc
cupation=&F_HowLearn=&F_FirstName=&F_LastName=&F_Email=&F_Referral=impulse&b
tnAction=Submit+Your+Background+Data+and+Join+th . . .

Time:
Wednesday, March 17, 2004, 2:01:23 PM

More information:
Microsoft Support

Relevant Pages

  • Re: IIS5 Application Protection
    ... > I have an application that uses .asp code and an access database which runs ... > of low (which they will not allow for security reasons). ... CCSI - CCSE 2000 - CCSE+ NG ...
    (microsoft.public.inetserver.iis.security)
  • Re: IIS5 Application Protection
    ... > I have an application that uses .asp code and an access database which ... Only asp scripts are allowed (no ... Tom Kaminski IIS MVP ...
    (microsoft.public.inetserver.iis.security)
  • IIS5 Application Protection
    ... I have an application that uses .asp code and an access database which runs ... on my ISP's Win2k Server. ... such a fashion that it will only run with the application protection setting ...
    (microsoft.public.inetserver.iis.security)
  • Re: Failed to acces the SQL Server table from MS Access by ODBC Li
    ... How can I provide the user name and password in the connection string? ... My link table is stored in the access database, I have checked the save password check box when I set up the odbc link table. ... because your asp code is running under the context of the ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • DB data insertion: No Luck Frustrated Newbie
    ... I'm still trying to get data to write to an access database. ... Internet Information Services ... Error Type: ... POST Data: ...
    (microsoft.public.inetserver.asp.general)
Loading