Site5 Q&A » MS Access .mdb & .ldb database corrupted?

MS Access .mdb & .ldb database corrupted?

In: Databases Asked By: georgwestermark [2

]

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.

3 Answers Answer this Question Now

Jun 26, 2015

Answer #1

I am sorry to hear of the troubles you are having. We do not run MSSQL on our servers, so our experience will be limited. However, I did some digging on this for you and may have found a possible solution.

As you have tried repairing the database, with no success, you might try importing the corrupted table into a new database. Simply create a new, empty database and import the specific table into it. The software should repair the table as it imports, and you can then move it back.

Please note that I cannot guarantee that this will work, and I STRONGLY suggest you back everything up before you do this.

Answered By: jdavey [359

]

Answer #2

Try renaming the .ldb file to a different extension like .ldbx. It’s been ages since I used Access but that .ldb used to be the list of users who were connected, and sometimes we had to get everyone out of the app and delete that file. That might reset things. If it doesn’t, just rename it back.
Read more here: http://myitforum.com/myitforumwp/community/groups/windows-8/forum/topic/cant-open-mdb-file-how-view-it/

Answered By: georgwestermark [2

]

Answer #3

I too faced this issue I was really disappointed after having this error. I used Compact and Repair to resolve corrupt database but it doesn’t work. Luckily I found an amazing tool that helped me to fix this. Not being a technical guy it is very hard to go with any other manual process so I prefer moving with this third party repair tool.

http://msaccess.filerepairtool.net/

Answered By: alva114 [2

]

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »