Novice: 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 Corruption
The 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 article number below to view the article in the Microsoft Knowledge Base:
ACC2002: How to Troubleshoot and Repair a Damaged Access 2002 Database
The following Knowledge Base article provides information about preventing corruption in Microsoft Jet 4.0 databases. For additional information about minimizing database corruption, click the article number below to view the article in the Microsoft Knowledge Base:
HOW TO: Keep a Jet 4.0 Database in Top Working Condition
Additional Troubleshooting Resources
The following Knowledge Base articles may be of additional assistance to you in troubleshooting problematic database files. For additional information about troubleshooting fatal errors in Access 2002 on Windows 2000, click the article number below to view the article in the Microsoft Knowledge Base:
ACC2002: How to Troubleshoot Fatal System Errors in Access 2002 Running on Microsoft Windows 2000
For additional information about troubleshooting fatal errors in Access 2002 on Windows Millennium, click the article number below to view the article in the Microsoft Knowledge Base:
ACC2002: How to Troubleshoot Fatal System Errors in Access 2002 Running on Windows Millennium
For additional information about a corrupted project error when attempting conversion, click the article number below to view the article in the Microsoft Knowledge Base:
ACC2002: Corrupted VBA Project Error When You Try to Convert a Database
After 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.
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.
Microsoft 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.
The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
Technical Support from Microsoft
Microsoft Support professionals can assist you in walking through the steps included in the referenced articles. Although Support professionals 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