Very frustrating.



Currently I have asp pages that connect to an Access 2000 database using a 

system DNS. This database is accessed through the web as well as directly 

with MS Access. What I have been finding is that over time (usually a few 

days) the asp pages fail with the following errors



HTTP 500.100 - Internal Server Error - ASP error

Internet Information Services

Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC 

Microsoft Access Driver] The database has been placed in a state by an 

unknown user that prevents it from being opened or locked.

/dreamweaver/Work_Order_Querys/Query_El_notcomp_both_priority.asp, line 29

Page:

GET /dreamweaver/Work_Order_Querys/Query_El_notcomp_both_priority.asp 



OR



HTTP 500.100 - Internal Server Error - ASP error

Internet Information Services

Error Type:

Provider (0x80004005) Unspecified error

/dreamweaver/Work_Order_Querys/Query_El_notcomp_SD_priority.asp, line 29

Page:

GET /dreamweaver/Work_Order_Querys/Query_El_notcomp_SD_priority.asp



995 of the errors are the last one.



The internet guest account has full permissions to the directory that 

contains the database. Page Timeout value is already set at 5000.



line 29 is:

Query_All_Work_Orders.ActiveConnection = MM_Web_Work_Order_STRING



Any ideas why this is happening? I read somewhere that you can?t allow 

access to a db file through asp and MS Access at the same time?



This is really getting frustrating, as I need to reboot the box every few 

days.



Any help would be greatly appreciated!

I'd avoid Macromedia Ultradev for starters.



Secondly I'd avoid the ODBC Driver:

www.adopenstatic.com/faq/whyOLEDB.asp



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "candyman" <candyman660@h...>

Subject: [access_asp] asp pages fail every few hours/days





: Very frustrating.

:

: Currently I have asp pages that connect to an Access 2000 database using a

: system DNS. This database is accessed through the web as well as directly

: with MS Access. What I have been finding is that over time (usually a few

: days) the asp pages fail with the following errors

:

: HTTP 500.100 - Internal Server Error - ASP error

: Internet Information Services

: Error Type:

: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC

: Microsoft Access Driver] The database has been placed in a state by an

: unknown user that prevents it from being opened or locked.

: /dreamweaver/Work_Order_Querys/Query_El_notcomp_both_priority.asp, line 29

: Page:

: GET /dreamweaver/Work_Order_Querys/Query_El_notcomp_both_priority.asp

:

: OR

:

: HTTP 500.100 - Internal Server Error - ASP error

: Internet Information Services

: Error Type:

: Provider (0x80004005) Unspecified error

: /dreamweaver/Work_Order_Querys/Query_El_notcomp_SD_priority.asp, line 29

: Page:

: GET /dreamweaver/Work_Order_Querys/Query_El_notcomp_SD_priority.asp

:

: 995 of the errors are the last one.

:

: The internet guest account has full permissions to the directory that

: contains the database. Page Timeout value is already set at 5000.

:

: line 29 is:

: Query_All_Work_Orders.ActiveConnection = MM_Web_Work_Order_STRING

:

: Any ideas why this is happening? I read somewhere that you can?t allow

: access to a db file through asp and MS Access at the same time?

:

: This is really getting frustrating, as I need to reboot the box every few

: days.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~