Error trying to open a db

B

Brian

how do I resolve this error:

THE DATABASE HAS BEEN PLACED IN A STATE BY USER 'ADMIN' ON
MACHINE XXX THAT PREVENTS IT FROM BEING OPEN OR LOCKED.


Access 2000, I believe it's set to Shared, and Edited
Record.

Any ideas?
 
J

Joan Wild

Likely someone closed the database in some abrupt manner (Ctrl-Alt-Del, or
power button).

Go to the folder where the mdb is, and with everyone out, look for and
delete any LDB files you see.

Also, if you have multiple users accessing this mdb, you should split it
into frontend/backend; put the backend on the server, and give each user a
copy of the frontend (linked to the tables on the server) on their computer.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime error 3734 1
database is placed in a state in access 2007 1
Error 3734 - Database is locked 1
Multiple users on an Access database 6
How do I clear a form? 0
Database has been placed in a state by user 0
Multi-User Error Message 2
Security problem 4

Top