Unable to access database - locked

  • Thread starter Thread starter tshad
  • Start date Start date
T

tshad

We have a database that was accidently locked and won't unlock.

There is an LDB file there but not sure if we can just delete it?

Thanks,

Tom
 
Instead of deleting it, just cut and paste it somewhere else. Not sure if
that will let you in or not though. Is it set to single user?
 
Hi tshad,

My guess is if you have an LDB someone has it open. However, to try an solve
your existing probelm. Open Access and create a blank database and save it to
your desktop. Then, import everything out of the locked database into the new
one you created. This should reset the database so you can open it again.
Give a try, take about five minutes.
 
I don't think that this is a good -- long term-- solution.

If you get sick and tired of a database that craps out-- then UPSIZE
to SQL Server.

HTH

-Aaron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
.ldb is not being deleted from one user's PC 5
looking for a way to unlock a back end mdb file 16
database locked 1
Access database locked up 4
How to delete ldb files when no one is in the database. 22
Subform/Subreport:Call Listing Subform 6
Can't delete LDB file 2

Back
Top