Error trying to open a db

  • Thread starter Thread starter Brian
  • Start date Start date
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?
 
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.
 
Back
Top