Discussion Locked

Access 2000 Database Repairing Problem

0 helpful
11 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

An important database of mine was corrupted. The situation is that when I open that database it asks for a password (because the database is password protected). When I enter password is say that "You or another user may have unexpectedly quit Microsoft Access while a Microsoft Access Database was open. Do you want Microsoft Access to attempt to repair the database? Yes/No". On choosing Yes it gives error message as "Not a valid password." and after that it gives message that "The database can't be repaired or isn't a Microsoft Access database file."

I have tried to recover the database by creating a blank database and importing tables from the corrupted database but the same messages appears as above. I shall be very grateful if any one can help me in this regard.

Is there any software out there which I can use to recover the data? Thanks for the info.

11 replies

by donq

You may truly have a problem you can't repair because you have already tried many of the things I would suggest.

Have you opened a new database, imported everything and closed it without doing anything AND THEN compacted and repaired the file BEFORE attempting to Open it?

If that does'nt work only a restore is going to help youu I am afraid??? Sorry

by shmaltz

You say it was password protected, was it protected just with a password or it also had users set up?
If you also had users set up then you have to make sure the password and user name you are using has permission to repair the database.
Also try; after you open the database and you enter the password to clear the password and then repair it.

by shmaltz

Try to unprotect the database when you are logged on, after you enter the password befroe you try to repair it.

by shmaltz

You say that it ask you for a password when you open it. So give it the password and try to uprotect the database.
One more thing, make sure that you open the database in exlusive mode (you choose that in the open dialog box).

by it_cowboy

First thing i would look for is a rogue .ldb file. It will be of the same name as the database. This file handles locking on an open mdb file, and should disappear when no users are accessing the db, but sometimes they hang around. If there is one, try to delete it. If its on a network drive, you may even need to reboot the server to be able to delete it.

If thats not in existence, the only other thing I could suggest is to attempt to access the db through code, as opposed to the gui.good luck!

This discussion is closed to new replies.