Compact and Repair MS Access Database using ADO and JRO
Posted by ginxwizard on 6 October, 2009
No comments yet
This item was filled under [ FREE SOURCE CODE, Visual Basic 6.0 ]
This function uses the Microsoft Jet and Replication ObjectsLibrary (part of ADO) to compact and repair a Microsoft Accessdatabase. A project reference is required to the Microsoft Jetand Replication Objects Library.You may want to add error handling to this procedure, or tothe function that calls it as the compact and repair may fail,for instance, if exclusive access cannot be gained to thesource database.
