Database is damaged and locked

[Guest]

My database became damaged and now when opening I got the option to Repair
the database. Halfway through the repair, it stalled out and now when I try
to open, I get the message that the database is locked and in use by someone
else. It is not a shared database. Also, I do not see the.ldb file, which i
usually see when a db is in use. Any suggestions on how to open/repair my
database would be greately appreciated.

Thanks

 

[Joan Wild]

I suggest you copy the database first.

Try compacting your database using Jetcomp, available at
http://support.microsoft.com/?id=273956

If that fails, try creating a new database and importing objects from the
old.

If that fails, you can try www.pksolutions.com

For more information on corruption, see
http://www.allenbrowne.com/ser-25.html and
http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Guest]

I copied the database, but the new one doesnt let me open it because it says
it is in use, but of course isnt. And same problem with imports. It wont
import, because it says the database is locked and in use. Grrrr. I'll try
this website, but if anyone has any other suggestions....

Thanks!

 

[Jeff Boyce]

Is your database split into front-end and back-end? Is your back-end/data
someplace where a backup is regularly made? Do you have backups of either
the database (one file) or the separate front- and back-ends?

Jeff Boyce
<Office/Access MVP>

 

[Joan Wild]

Did you try Jetcomp?

 

[Guest]

I was blocked from downloading Jetcomp due to security restrictions at work.
At this point, I have asked them to restore my database from Friday's backup.
I havent gotten an answer yet, but I am hopeful. Thanks for your help