1

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.

2
  • 1
    and you have no backup? I'd say the chance of opening that .mdb is slim.
    – Hannah Vernon
    Commented Jul 19, 2014 at 16:17
  • Shut down cleanly or crashed/powered off?
    – Tom V
    Commented Oct 4, 2016 at 19:46

2 Answers 2

1

Open in Safe Mode

Open the Access application with the following option:

C:\> "C:\Program Files (x86)\Microsoft Office\Office12\msaccess.exe" /safe "C:\path to mdb file\your.mdb"

Open and compact/repair

Open the Access database with the /compact parameter:

C:\> "c:\program files\microsoft office\office12\msaccess.exe" /compact "C:\path to mdb file\your.mdb"  

Reference: Command-line switches for Access

Open the database and repair

In Microsoft Access 2000 and later, compact and repair functionality is combined under /compact. The /repair switch is supported for backward compatibility

Open the Access database and repair it with the following parameter:

C:\> "c:\program files\microsoft office\office12\msaccess.exe" /repair "C:\path to mdb file\your.mdb"  

Bypass Startup Options

Alternatively try opening the Access database while bypassing any startup options:

  • Hold down SHIFT key
  • Open Microsoft Access database with a double-click on the MDB file
  • If messages pop up, keep SHIFT depressed and confirm any messages
  • Wait for Access Database to open

Reference: Bypass startup options when you open a database

Last possibility

Buy a repair software

1
  • Make a copy of the file before doing anything
    – Paul
    Commented Jan 15, 2018 at 8:58
0

Please try by deleting the .ldb file. This will clear the lock on the mdb file and should allow you to get in and try and recover your data.

Not the answer you're looking for? Browse other questions tagged or ask your own question.