I get this error when I open my database in MS Access which resides in the

same server as the asp page.  If I close the DB the asp page works fine

when the database is open I get the following error:



Microsoft JET Database Engine error '80004005' 



Could not use ''; file already in use.

That's because when you have the database table open, ALL the records are in 

edit mode i.e. Pessimistic Lock. This means you can only READ records from 

the database through your ASP.



neil





>From: "Dipal Patel" <dpatel@a...>

>Reply-To: "ASP Databases" <asp_databases@p...>

>To: "ASP Databases" <asp_databases@p...>



>Subject: [asp_databases] Microsoft JET Database Engine error '80004005'

>Date: Fri, 17 Nov 2000 19:11:07 -0000

>

>I get this error when I open my database in MS Access which resides in the

>same server as the asp page.  If I close the DB the asp page works fine

>when the database is open I get the following error:

>

>Microsoft JET Database Engine error '80004005'

>

>Could not use ''; file already in use.

>

Dipal:  If I understand right, you get the error when the db is open in

Access design view?  Access has the db locked, preventing any other

application from using it.



I hope this helps.