question

georgwestermark avatar image
georgwestermark asked

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.
access
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

eivinlien avatar image
eivinlien answered
Comprehensive tool which repairs and recovers databases of MS Access. Access File Recovery Software is an intelligent solution to fix all corruption issues in ACCDB and MDB database files and saves all the deleted records and objects like indexes, queries, relations and tables, on new database. Read more here: [ http://myitforum.com/myitforumwp/community/groups/windows-8/forum/topic/cant-open-mdb-file-how-view-it/][1] [1]: http://myitforum.com/myitforumwp/community/groups/windows-8/forum/topic/cant-open-mdb-file-how-view-it/+
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image
David Wimbush answered
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. Incidentally, if this is a multi-user app, you can probably move the database to SQL Server Express pretty easily. It's free and it doesn't do this sort of thing. Well worth checking it out.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.