could not update; currently loked by user 'admin' on machine

T

tclbobo

in our dept we have a database that allows multiple users and has been set up
that way but periodically one of the associates will get this error message
preventing anyone else from entering the database . It happens once or twice
a week but never everyday and it isn't always the same associate who locks it
up . Our systems help group is clueless and I have not been able to figure it
out.
 
J

Joan Wild

That can occur if someone abruptly exits the database (ctrl-alt-del or power
failure).

With everyone out of the mdb, look for a ldb in the same folder. If you see
it, delete it.

Although the database allows multiple users, it is always wise to split the
database. Multiple users sharing the same file inevitably leads to
corruption.

When you split it, you'll have a backend (tables/relationships) mdb on the
server, and each user will have a copy of the frontend (all other objects)
mdb on their workstation. The frontend will contain linked tables - linked
to the common backend on the server.

Ensure all users have read/write/create/delete permissions on the folder
where the backend is located.
 
Top