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