Freeing up an Access Database locked by an unknown user

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
GPSPOWAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"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
0
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
I usually delete the lock file - if access ends abnormally it could remain behind.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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

Glen
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Tried what ?
0
 
GPSPOWAuthor Commented:
Thanks

Worked.

Glen
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.