Cannot open .mdb file

[Marco Yee]

Hi,

I have a mdb file in server. A user is doing input. Others cannot open this
mdb file and got this message "the database has been placed in a state by
user 'Admin' on machine 'ACNT01' that prevents it from being opened or
locked"

I have to let the input user close this file, then others can open it. We
are using this file for a long time. This thing happens rarely.

Any help is appreciated.

Thanks
Marco

 

[Joan Wild]

I have a mdb file in server. A user is doing input. Others cannot
open this mdb file and got this message "the database has been placed
in a state by user 'Admin' on machine 'ACNT01' that prevents it from
being opened or locked"

That usually happens if someone exits the database abruptly (power failure,
ctrl-alt-delete). Have everyone get out, and then look for a file in the
same folder as the mdb, but with a ldb extension. Delete the ldb file.
Open the mdb and use Tools, Database Utilities, Compact and Repair.

I have to let the input user close this file, then others can open
it. We are using this file for a long time. This thing happens rarely.

You really should split the database, leaving the backend
(tables/relationships) on the server, and give each user a copy of the
frontend (all other objects) on their computer, linked to the tables in the
backend.