Question Back-end of db thinks user is still logged on

Birdman895

Registered User.
Local time
Today, 10:53
Joined
Apr 19, 2012
Messages
62
I have the back-end of an Access 2010 database running on a network drive. The database thinks that there is still someone logged into it. I have made sure that there is no one actually logged into it.
In file explorer there is the second file (record-locking) still present and I can't delete it. Also if I open up the db I can't make any changes to the tables. With word or excel you can delete the temporary file that shows a file as being open, but obviously not with Access:)
Help
 
Make sure that MSACCESS.EXE isn't still running in the user's Processes (on the Task Manager). Failing that try shutting the computers down that you believe are to blame. If the locking file is still there then someone has it open.
 
Thanks, I will try that this afternoon
 
You also need to make sure that all users have full permissions (read, write, delete) on the file where the back end is stored, so the lock file can be deleted when the last user closes their front end.
 

Users who are viewing this thread

Back
Top Bottom