PRB: RepairDatabase Method Is No Longer Available in DAO 3.6

If you issue a DbEngine.RepairDatabase method after you change your project references from Microsoft DAO 3.51 Object Library to Microsoft DAO 3.6 Object Library, you may receive the following error message: Or, you may notice that the method is not available through IntelliSense when you issue a DbEngine.RepairDatabase method.

In Data Access Object (DAO) 3.6, the RepairDatabase method is no longer available or supported. This is by design to match Microsoft Jet 4.0.

If you need this functionality, you can use the CompactDatabase method, which also repairs a Microsoft Jet database.

Steps to Reproduce Behavior

1. Create a new standard EXE project in Visual Basic.
2. From the Project menu, click Reference, and then click Microsoft DAO 3.51 Object Library.
3. Paste the following code in the code window:

   DbEngine.RepairDatabase
   						

   Notice that RepairDatabase is available in the list of methods.
4. Change you project reference to Microsoft DAO 3.6 Object Library.
5. Paste the following code in the code window:

   DbEngine.RepairDatabase
   						

   Notice that RepairDatabase is not available from the list of methods.

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base: