We help IT Professionals succeed at work.

Record Lock on Database will not go away

seamus9909
seamus9909 asked
on
961 Views
Last Modified: 2017-03-21
I have a Backend Access Data Base, that has an associated Record Lock File, yet noone is logged into the database.  Every time I try to delete it it says another user has the DB. However I do not see who that person is.

How do I find out who has it locked.
Comment
Watch Question

CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
i have rebooted the server and still it shows being locked?
John TsioumprisIT Supervisor
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Check your antivirus on both your machine and server....disable them and try again...
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
Did you try deleting the lock file after the reboot?  Rebooting won't delete the file but it should kill what ever process was locking it.

Author

Commented:
Hi Yes i did try and delete it after reboot

Author

Commented:
Thank you that worked
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
It's a little pesky and most network admins are loath to reboot a server if they don't have to.  You just have to convince them to do it but in your case, you were lucky enough to have the power to do it yourself.

Author

Commented:
Yes  now on to my bigger issues
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
Couple other comments:

1. A LDB will also get left behind if a user abnormally disconnects from the DB.  As Pat said, all users should have delete priv's.   Check this and then if the LDB continues to get left behind, you've got other issues.

2. It is possible to release the lock on the LDB without rebooting the server.   If it's a network connection, you just have to close the session.  That's done from Computer Managernt, Files and Shares.

  If the lock is from a local logon, then you would need to use something like process Explorer that can find the handle and kill it.

Jim.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions