Database Locking itself 
Author Message
 Database Locking itself

I am writing an Access database which needs to be able to be accessed by
both its internal forms, and by ASP scripts at the same time.  I have done
this before so i know that i can do it.  With the current database, if i
have a form open which is linked to a table, my ASP script cannot open the
database, getting an error message "The database has been placed in a state
by an unknown user which prevents it from being opened or locked"  And if i
then close the Access form, and try to run the ASP script again i get an
"Unspecified Error" until i reboot my machine.  Now i have checked all the
code behind my forms and there are no recordsets left open anywhere, and the
database is set to shared not exclusive, and there are no record locks,  yet
this is still occuring.  Any help greatly appreciated.

Sat, 19 Jul 2003 15:09:02 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Custom Locking code for Database Locked in VB4 with Access 2.0 - HELPPPPPP

2. Compact Access Database into itself

3. Multi Machine how to Acess and lock the same database ( No use the Server database)

4. While using a DataBase on a network: Database locked

5. Database Locked Exclusive

6. Database locking on loop

7. Database is Locked

8. Locked VBA in an Access Database

9. Lock Down Your Database

10. ASP locks up database

11. Locked database

12. SQL Server Project Database Locked


Powered by phpBB® Forum Software