Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to troubleshoot corruption in a Microsoft Access database
Article ID: 306204 - View products that this article applies to.
This article was previously published under Q306204
For a Microsoft Access 97 version of this article, see 306829
For a Microsoft Access 2002 version of this article, see 304701
For a Microsoft Access 2003 version of this article, see 824271Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
There are a number of reasons corruption can occur in a Microsoft Access database. This article provides a list of references to Microsoft Knowledge Base articles that may assist you in resolving corruption in your database.
Troubleshooting and Preventing Database CorruptionThe following Knowledge Base article provides the troubleshooting steps that Support Professionals follow when they try to recover a corrupted database. For additional information about troubleshooting and repairing an Access database, click the following article number to view the article in the Microsoft Knowledge Base:
209137The following Knowledge Base article provides information about preventing corruption in Microsoft Jet 4.0 databases. For additional information about minimizing database corruption, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/209137/ )How to troubleshoot and repair a damaged Jet 4.0 database in Access 2000
(http://support.microsoft.com/kb/300216/ )How to keep a Jet 4.0 database in top working condition in Access 2000
Additional Troubleshooting ResourcesThe following Knowledge Base articles may be of additional assistance to you in troubleshooting problematic database files.
For additional information about receiving an unexpected error when opening a database, click the article number below to view the article in the Microsoft Knowledge Base:
277924For additional information about a corrupted project error when attempting conversion, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/277924/EN-US/ )ACC2000: "Unexpected Error 35012" When You Open a Database
248960For additional information about troubleshooting invalid page faults, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/248960/EN-US/ )ACC2000: Error Message: "Visual Basic for Applications Project in This Database Is Corrupt"
208488For additional information about project corruption in a database, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/208488/EN-US/ )ACC2000: How to Troubleshoot Invalid Page Faults in Microsoft Access 2000
280433For additional information about conversion errors with a large number of forms, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/280433/EN-US/ )ACC2000: Unexpected Project Corruption in Access Database
(http://support.microsoft.com/kb/225949/EN-US/ )ACC2000: Error Converting a Database with a Large Number of Forms That Have Modules
Data RecoveryThe following may be helpful in attempting to recover data from a damaged or corrupted Access database.
For additional information about recovering data from a corrupted table, click the following article number to view the article in the Microsoft Knowledge Base:
247771For additional information on recovering data from a corrupted table using MSQuery, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/247771/ )How to recover data from a damaged database table or a corrupted database table in Access 2000, Access 2002 or Access 2003
304561After completing the troubleshooting articles listed above, if you are still unable to recover your database, your data may still be recoverable. There are a number of third-party companies that specialize in data recovery.
(http://support.microsoft.com/kb/304561/EN-US/ )ACC2000: How to Use MS Query to Recover Data from a Damaged Jet 4.0 Database
The following companies are known to specialize in this area. You may be able to find additional companies that specialize in this area by searching on the Internet.
Action Front Data Recovery LabsMicrosoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.
Technical Support from MicrosoftMicrosoft Support professionals can assist you in walking through the steps included in the referenced articles. Although they can assist you with troubleshooting in your database, Microsoft cannot guarantee that an Access database can be recovered or that data can be recovered during this process. Because a Support professional will be working with your database, support of this nature is considered to be at an Advisory Services level.
Contacting Advisory Services:Advisory Services is an hourly fee-based, consultative support option that provides proactive support beyond your break-fix product maintenance needs. This is a remote, phone-based support option that includes working with the same technician for assistance with issues like product migration, code review, or new program development. This service is typically used for shorter engagements, and is designed for developers and IT professionals who do not require the traditional onsite consulting or sustained account management services that are available from other Microsoft support options. For information on Microsoft Advisory Services, refer to this Microsoft Web site:http://support.microsoft.com/gp/advisoryservice