How do I fix a corrupted MS Access database?

Solved/Closed
JohnBradl Posts 1 Registration date Friday February 20, 2015 Status Member Last seen February 20, 2015 - Feb 20, 2015 at 03:01 AM
 Punnu - Oct 11, 2016 at 02:30 AM
MS Access .mdb & .ldb database corrupted
I am using a A.mdb database. You know when connecting the database Microsoft automatically create a .ldb file. Unfortunately my PC shutdown when connecting the database. As a result after restart the PC I couldn't open the A.mdb file. The message shown A.mdb database is corrupted. A.mdb database was password lock but after corrupted if I give the valid password the database not open and showing the password not valid. Now I couldn't open the database. Now it shown A.mdb file with A.ldb file. Please advise me if PC shutdown with the connected .mdb database then why the database not recover after restart? Also I tried with the option Database Repair and Recovery.
Please advise me and thanks again for your kind co-operation.
Best Regards

3 responses

SimonGain Posts 1 Registration date Tuesday March 3, 2015 Status Member Last seen March 3, 2015 1
Mar 3, 2015 at 10:47 AM
If you are absolutely sure you were the only one in the database at the time, you can make a copy of the .mdb file (and not the .ldb) and try to open that file instead, possibly with the Repair option. It sometimes works.
2
You can try Access recovery tool to repair corrupted database. If database cannot be opened at all, even with pressed Shift, try to import database objects to new database.
0