How to troubleshoot corruption in a Microsoft Access database (306204)


The information in this article applies to:

  • Microsoft Access 2000
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).

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:

Cost: $210 per hour, minimum one hour, maximum 40 hours.

Phone incident: 800-936-5200 (all incidents must be submitted by phone)

To process, $210 will be charged to your credit card. A Microsoft support professional will contact you within 24 hours to discuss the work you want to have done. At that time, an evaluation will be made regarding how many hours the project will take. If the project will take more than one hour, additional work will be done on a contractual basis.
Modification Type:MajorLast Reviewed:8/12/2005
Keywords:kbcorrupt kbtshoot kbhowto KB306204
©2004 Microsoft Corporation. All rights reserved.