Unable to access database - locked

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
 
M

Matt

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?
 
S

Stockwell43

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.
 
A

a a r o n . k e m p f

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

looking for a way to unlock a back end mdb file 16
database locked 1
Access database locked up 4
ldb locked 4
How to delete ldb files when no one is in the database. 22
Can't delete LDB file 2
Unlocking a Database 7
Who has Record Locked?? 8

Top