the database has been placed in state by user "Admin"

[charleslau]

hi,

Everyone know this error? the database has been placed in state by user "Admin"!

We are using a shared database in Access 2003 that is still in Access 2000
format. When more than one user has the database open (by using the vb.net), the following error
message appears "The
database has been placed in a state by user 'Admin' on machine XXXXX that
prevents it from being opened or locked."

How to slove this error? please help! Urgent!

 

[MicroE]

I’m not sure what you mean by using “Access 2003 that is still in Access 2000” and “by using the vb.net”. Are you front ending the database with both Access 2003 and VB.Net? Has your database been split into a FE/BE solution?

http://support.microsoft.com/kb/247180

http://www.myaccesstips.com/deploy/deploy.html

 

[Dennisk]

you sometimes get this error if a run time error occurs and the db goes into debug mode.

 

[charleslau]

Thank your (MicroE, Dennisk) reply to me !

My program is developed in vb.net and my databases is put in the server! so, i using this program which connect to the access databases over the LAN!

When more than one user has connect to database at the same time, the following error
message appears "The
database has been placed in a state by user 'Admin' on machine XXXXX that
prevents it from being opened or locked."

So, Is i need to do the solution (from MicroE) to solve my problem?

1. Split the database into a front-end/back-end application.
2. Save the front-end application as a mde file (or ade for adp files).
3. Create a folder on a network share for the database. The following files should be placed in the folder.
-Application data file (back-end - .mdb)
-Application mde file (front-end - .mde)
-Batch file (used for startup - .bat)
4. Deploy the front-end mde file on each users local PC

Thanks!