Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
ACC2000: How to Recover Data from a Corrupted Table by Using the DAO Method
Article ID: 815280 - View products that this article applies to.
This article applies only to a Microsoft Access database (.mdb).
Moderate: Requires basic macro, coding, and interoperability skills.
This article describes how to recover data from a corrupted table in an Access database. You can do this by using the Microsoft Data Access Objects (DAO) db.Execute method. You can use the db.Execute method when you cannot recover your data by using either MS Query or the Compact and Repair Database utility in Access.
Note The sample code in this article uses Microsoft Data Access Objects. For this code to run properly, you must reference the Microsoft DAO 3.6 Object Library. To do so, click References on the Tools menu in the Visual Basic Editor, and make sure that the Microsoft DAO 3.6 Object Library check box is selected.
To recover the data from the corrupted table in Access, follow these steps:
For additional information about troubleshooting the corrupted database and how to recover data from a corrupted table, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/306204/EN-US/ )ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
(http://support.microsoft.com/kb/209137/EN-US/ )ACC2000: How to Troubleshoot and Repair a Damaged Jet 4.0 Database
(http://support.microsoft.com/kb/247771/EN-US/ )ACC2000: How to Recover Data from a Damaged (Corrupted) Table
(http://support.microsoft.com/kb/304561/EN-US/ )ACC2000: How to Use MS Query to Recover Data from a Damaged Jet 4.0 Database