80004005: database has been placed in a state by an unknown user

[Guido Blechl]

Hi,

who can help me? Thanks for all answers in in advance.

I have an ASP-page, that connects via ODBC to an MS-Access 2000 database.

It works perfectly if the database is not open. But: When I'm opening the
Access mdb-File and want to make changes or insert data using an Access-form
AND refresh the ASP-Pagr after this, the following error occures:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[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.

More datails:

.) The error only occures, when editing an Access-Form. It is possible to
edit Access-Tables.

.) I use this ASP-Code:

set connection = Server.CreateObject("ADODB.connection")

connection.Mode = adModeRead

connection.open "xyz" (xyz is the Data Source Name, which is configured by
the odbc control panel)

...

connection.close

set connection = nothing

set recordset = nothing

.) I use

Webserver: Windows 2000 Server SP2 and latest patches

Microsoft Access 2000 with MS Office SR2

ODBC connection with MS Access 4.00.6019.00

.) The directory of the databases has full permissions for the IUSR.

[J. Paul Schmidt]

Yes, don't even try to open the database on the Web, just FTP it up or back
down and connect to it. And you might want to have some way in your ASP pages
(perhaps using a value in an included file such as gstrDBIsUp = False) to lock
out users (perhaps giving them a user-friendly page saying temporarily down for
maintence) while you are doing DB maintence...

Best regards,
J. Paul Schmidt - ASP Web Developer
http://www.Bullschmidt.com - To put live data on the Web...