How do I fix a corrupted MS Access database? [Solved/Closed]

JohnBradl 1 Posts Friday February 20, 2015Registration date February 20, 2015 Last seen - Feb 20, 2015 at 03:01 AM - Latest reply:  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
See more 

4 replies

Best answer
SimonGain 1 Posts Tuesday March 3, 2015Registration date March 3, 2015 Last seen - Mar 3, 2015 at 10:47 AM
Thank you
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.

Thank you, SimonGain 1

Something to say? Add comment

CCM has helped 1679 users this month

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.
kavita_pathak 1 Posts Monday August 31, 2015Registration date August 31, 2015 Last seen - Aug 31, 2015 at 03:48 AM
Thank you
The .mdb file of MS Access Database is sometime damage of corrupted due to various reasons like improper shutdown, virus attack, running multiple application etc. Corruption in MDB file sometime creates problems for its user at the time of accessing and show the error of password. Below I mentioned a blog post link which helps you to work with corrupted MS Access Database files.