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.
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 ZhaoTechNet Community Support
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.
- Marked as answer by Sigeferth Singer 4 hours 20 minutes ago