We help IT Professionals succeed at work.

Freeing up an Access Database locked by an unknown user

GPSPOW
GPSPOW asked
on
I have an Access database that shows a lock on it by a user.  However, all users who have privileges to the location of the database are not logged in or using the Db.

What happens on occasion is that the report the user runs gets hung up and they abort the process but the Db stays open.

Is there a way to unlock the Db without rebooting the server?

Thanks

glen
Comment
Watch Question

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
"the user runs gets hung up"
So, whereas Access  may appear to be visually closed, it's likely stuck in memory - keeping the Lock file open. You can use Task Manager>>Processes>>MSACCESS.EXE  .... and kill that task.

mx
Lee W, MVPTechnology and Business Process Advisor
Most Valuable Expert 2013

Commented:
I usually delete the lock file - if access ends abnormally it could remain behind.

Author

Commented:
I tried that.  I could not.  Blocked by unknown user.

Glen
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Tried what ?
President / Owner
Fellow 2019
Most Valuable Expert 2017
Commented:
If it's across a network share, you can kill the connection from Share and File Management....look at open files.

If MSAccess.exe is running on the server itself and you've already killed the task, then it's an orphan lock and would need something like process explorer to find the file handle and close it.

 but the answer is yes, it can be done without rebooting the server.   What OS are you dealing with?

Jim.

Author

Commented:
Thanks

Worked.

Glen