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.
|