TntConnect
Helping you build powerful connections for a lifetime of ministry...

How do I recover from a corrupted database file?


Table of Contents

It is our pleasure to provide this software free of charge to help you in your ministry.  We're so thankful for our partners who make this possible!

About TntWare

Page Details

First published by:
Troy Wolbrink
on 10 Oct 2008
Last revision by:
Troy Wolbrink
on 3 Nov 2013
8 people found this article useful.

57% of people found this useful
How do I recover from a corrupted database file?

Your database file might be corrupt if you begin to receive an error such as the following:

  • The Microsoft Jet database engine cannot find the input table or query...
  • Unrecognized database format...
  • The Microsoft Jet database engine stopped the process because you and another user ...

What can you do in this situation?  You have a few options:

1.  You can try to repair your database in TntMPD.  Under the "File" menu, click on "Rebuild Database".

2.  TntMPD takes auto-backups every time you close the program.  Under the "File" menu, click on "Restore" to try to find a good working recent backup.  Note: Be sure to check the box for "Include backups of other databases." if you recently moved your database.

3.  Perhaps you have a backup of your database file on another computer or external drive.  If you don't already have a good automated backup solution, be sure you keep your TntMPD database on Dropbox.  This way you have automatic continual backups of your database from the last 30 days.

4.  You can try to open the database in Access 2010.  Access 2010 has enhanced database repair functionality.  If this works, in TntMPD you should [File | Utilities | Rebuild Database] to ensure the database structure is correct.

5.  As a last resort, you can:

Note: Be sure to check your disk for errors, as it's quite possible that your hard disk is failing:  http://www.microsoft.com/windowsxp/using/helpandsupport/learnmore/tips/kbtip.mspx

Note to Parallels users:  Sometimes these corruptions occur because Windows is not properly shut down. If you exit Parallels the wrong way, this can be similar to pulling the plug on the computer (which is a bad thing to do). So be sure to either suspend Parallels, or choose "Turn Off Computer" from the Windows Start menu when you're done with TntMPD.  It's also important that you keep your database on the local C: drive within Parallels.  This way if Parallels suspends, it's preserves the state of the virtual hard drive in a consistent way.  If it's important that you keep backups of your database on your Mac partition, then configure your auto-backup location appropriately.

Recent Comments

By: Camaleon Posted on 18 Oct 2012 5:52 PM

Troy,

Windows files got corrupted and my computer shut down completely to the point that they had to install the programs again.  I was wondering if there was a way to recover my TnTMPD database that we have been working for the past year?  Thank you.  

By: Troy Wolbrink Posted on 27 Oct 2012 8:11 PM

Cameleon, if you don't have a backup, you're only course of action is to try to recover your existing database.  This FAQ article describes the things to try.

By: ConnorPhillips Posted on 14 Dec 2012 8:59 PM

I am helping someone who recently changed computers. The old computer used version 2.1 r77 and has now been wiped.  All of the files from that computer are now on the new one, including his .mpddb file.  I installed 2.1 r88 on his computer and tried opening the file, and it said the file was an "Unrecognized database format". Under details it says it throws this exception: EOleException.  I have brought the file over to my computer, which runs 2.1 r77, and I get the same error. Under the file menu in TntMPD, I have tried rebuilding the database, restoring from backup, searching for a database, and compacting and repairing the database, all to no avail. I tried opening it in Access 2010, and it also says it is corrupt.

Is there anything else I can do here?

Thanks in advance.

By: Troy Wolbrink Posted on 20 Dec 2012 6:15 PM

Hi Connor, check out the last section of this article .... "5.  As a last resort" ...  I'd be willing to take a look at the file if you email it to me (to troy@wolbrinkfamily.com via www.yousendit.com)

By: Naitik Semwaal Posted on 27 Dec 2012 8:52 AM
100% of people found this useful

Neah.........stellar took a so much time to repair my corrupt database. So, for me it's useless. Instead of stellar I think sysinfotools works great in MS Access database corruption. I'm saying this as I have checked both of them. I checked their demo versions. Stellar took a so much time that I could not continue with it, so then I checked sysinfotools ms access repair. It took very less time and repair my corrupt database file.

It's great.

Do not believe me, check and finalize yourself.

Good luck.

Note: To know more about this software just visit http://www.sysinfotools.com.  

By: ammy_kiddy Posted on 27 Dec 2012 9:20 AM

Same from my side. I agree with Naitik Semwaal. I have checked Stellar once to repair my corrupt access database. I just wasted my time what I spent in a boring recovery process. But I have not checked sysinfotools yet, as I was done by something else.

Just thought to drop here something, hence did.

By: Jim Kercheval Posted on 14 Jun 2013 4:12 PM

I'm on a Macbook Air running Lion:

My database is corrupted as of yesterday

When I did a Rebuild got this error:  "Unrecognized database format 'Z:\Users\jameswkercheval\Library\Application Support\TntWare\TntMPD\Temp\tmp-BA14.tmp'. "

When I did a Restore I got this error: "Unrecognized database format 'Z:\Users\jameswkercheval\Desktop\Staff Active File\partners.mpddb'."

I also attempted compact and repair and got this error "Unrecognized database format 'Z:\Users\jameswkercheval\Desktop\Staff Active File\partners.mpddb'."

My last Carbonite backup is 14 days ago. I've been on MPD assignment for the past 2 weeks. I have two options. Go back two weeks to my notes and re-enter info as best I can. Or has anyone successfully gotten back their database another way or paid someone to repair a corrupt database?

Praise God He is sovereign over databases. He must want me to spend time on data entry and more frequent backups!  :)

By: Troy Wolbrink Posted on 14 Jun 2013 5:52 PM

Hi Jim,  Send me a copy of your database.  I'll see if I can recover it for you.  (troy@wolbrinkfamily.com)

By: ashish_lx Posted on 6 May 2014 1:12 PM

After reading all user opinion on different technology web-sites, I would like to say, you can try Kernel for Access Recovery tool !!! You can read more details about the software at here: www.nucleustechnologies.com

By: alva114 Posted on 23 Aug 2014 10:07 AM

Hi,

you can even use Access Repair tool that can easily re[air and recover the corrupt, damaged or inaccessible MS Access Database. For more visit here: accessrepairnrecovery.com

By: michaelfarm16 Posted on 14 Oct 2014 10:24 AM

Restore an entire database

When you restore an entire database, you replace a database file that is damaged, has data problems, or is missing altogether, with a backup of the entire database.

If the database file is missing, copy the backup to the location where the database should be.

IMPORTANT   If other databases or programs have links to objects in the database that you are restoring, it is critical that you restore the database to the correct location. If you do not, links to the database objects will not work and will have to be re-created, such as by using the Linked Table Manager.

If the database file is damaged or has data problems, delete the damaged file and then replace the damaged file with the backup.

Or try:

eRepair Access is a powerful Access database recovery solution for damaged *.mdb and *.accdb files created in Access 2000 and above.

For more information: access.erepairtools.com

And the similar question was discussed here: www.filerepairforum.com/.../314-ms-access-mdb-ldb-database-corrupted

By: CarolSoler Posted on 13 Mar 2015 1:32 PM

Great contributions guys, but these programs only recover tables, the problem is when you have to recover deleted records, modules, relations, the referential integrity and much more. So in these case i recommend www.cimaware.com/.../accessfix.php

By: Posted on 10 Sep 2015 11:28 AM

Access Recovery tool recovers complete data from corrupt or inaccessible Microsoft Access Database with all objects including modules, forms, reports, indexes, relations, and queries. It supports to recover MS Access files both (.MDB and .ACCDB). Supports almost all the versions of MS Access 2013/2010/2007/2003/XP/2000/97/95. Find more info here:- www.repairaccessdatabase.com

By: Edwards142paul Posted on 23 Oct 2017 5:46 AM

Well this particular Unrecognized Database Format Error usually comes when the Jet database engine was improperly shut down during the process of writing to disk. If you are looking for the fixes then go with this post and try the fixes mentioned in it…..you will surely overcome this issue.

Read more:

www.accessrepairnrecovery.com/.../how-to-repair-ms-access-error-3343-unrecognized-database-format-in-ms-access

By: Kingrylan08 Posted on 30 Jan 2018 7:15 AM

To recover your crucial data from Corrupt Access database files(MDB/ACCDB) try Access Recovery Tool.

Try Free Demo version, to Repair and View data with the corrupt database file.

To get free demo version visit:- www.accessrecoverytool.com

© 2018 TntWare | Privacy | Terms of Use