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.
4. You can try to open the database in Access 2007. Access 2007 has enhanced database repair functionality. If this works, you should click on "Rebuild Database" under the "File" menu in TntMPD to ensure the database structure is correct. If prompted for a database password, it's: tntMPD
5. As a last resort, you can try a paid file recovery service such as: http://www.datarevive.com/
|
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.
|