.mdb file completely corrupt after many attempts to recover it

I have an .mdb file that became corrupted about month ago. But I did not give a rush to it cause it was possible to copy parts of the data from this corrupt file into a new one. Also I canned run "/decompile" switch and Compact and Repair option worked fine. After some tips described above the .mdb file worked, but was still corrupted. And now it seems like it completely damaged. It just shows me an error: "The database .mdb can't be repaired or isn't a Microsoft Access database file" and nothing happens. I am looking for a good tip how to recover it, because it contains several days of my work and I have not a last backup =( that is very pity. 

February 24th, 2015 12:34pm

Hi,

We have definitely heard your frustration, and we're thinking about ways to recovery the data first and reduce the losses. Have you try to import the contents of the corrupted database that file into a new database? If no, please try to do it, steps:

  • From the File menu, choose Get External Data, Import, and select the  original database file. When the file is opened, click the Select All  button on each of the tabs in the Import Objects dialog box. This will  import all of the Tables, Queries, Forms, etc. from the original database  into the new database.
  • If your database contains custom menus, toolbars, or import/export  specifications, use the Options button to select these items.
  • If Microsoft Access stops the import at any point, it has probably hit a  damaged database object. You will then need to import the objects in that  group one-by-one, instead of selecting the whole group. Microsoft Access  will not allow damaged objects to be imported into a new database, so you  will need to re-create any objects you are unable to import.

Then, since you have try some steps about Access official "Compact and Repair" option , we may try some third party program.

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
February 26th, 2015 11:31pm

Well, you have tried /decompile, "compact and repair" and nothing works. Have you tried another feature from Microsoft - Jet Compact Utility? If not, run it. For some people it turned out more useful than "compact and repair".

As i understood from your description, you made some partial copies of the important data. Do you have these copies now? If yes, perhaps it would be easier to recover these copies than the whole corrupt file?

If nothing helps, then maybe it is time to run a third-party. Try this one - Recovery Toolbox for Access https://access.recoverytoolbox.com/

And i would recommend to split you database and get a available backup to prevent the future issues.

February 27th, 2015 2:23pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics