How to troubleshoot corruption in a Microsoft Access database

Article translations Article translations
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 824271.
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

Expand all | Collapse all

On This Page

SUMMARY

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.

MORE INFORMATION

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 following article number to view the article in the Microsoft Knowledge Base:
209137 How to troubleshoot and repair a damaged Jet 4.0 database in Access 2000
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 following article number to view the article in the Microsoft Knowledge Base:
300216 How to keep a Jet 4.0 database in top working condition in Access 2000

Additional Troubleshooting Resources

The 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:
277924 ACC2000: "Unexpected Error 35012" When You Open a Database
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:
248960 ACC2000: Error Message: "Visual Basic for Applications Project in This Database Is Corrupt"
For additional information about troubleshooting invalid page faults, click the article number below to view the article in the Microsoft Knowledge Base:
208488 ACC2000: How to Troubleshoot Invalid Page Faults in Microsoft Access 2000
For additional information about project corruption in a database, click the article number below to view the article in the Microsoft Knowledge Base:
280433 ACC2000: Unexpected Project Corruption in Access Database
For 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:
225949 ACC2000: Error Converting a Database with a Large Number of Forms That Have Modules

Data Recovery

The 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:
247771 How to recover data from a damaged database table or a corrupted database table in Access 2000, Access 2002 or Access 2003
For 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:
304561 ACC2000: How to Use MS Query to Recover Data from a Damaged Jet 4.0 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.

Action Front Data Recovery Labs

OfficeRecovery

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

Technical Support from Microsoft

Microsoft 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

Properties

Article ID: 306204 - Last Review: August 12, 2005 - Revision: 4.1
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbcorrupt kbtshoot kbhowto KB306204

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com