Printable View
I have found out that the object DAO 3.51 have a RepaitDatabase function. And DAO 3.6 dont have it.
Real-weird. Why oooohhhhh why. Does this mean i cant
repair a Access 2000 database? When i using DAO 3.6 references. Or do i have to go back to Access 97 when i want to use the Repair function ( DAO 3.51 ). But my question is. WHY??? ... But i think Access 97 is much better then the 2k version. :)
-Kayoca Mortation
Hi Kayoca,
I would think that if "RepairDatabase" isn't present in DAO 3.6, there must be some similar function that performs this vital operation under some other name. Check around for that. I can't be more specific because I haven't upgraded to Access 2000 yet.
All the best.
There's no RepairDatabase in DAO3.6 only because according to Microsoft, you should use ComapactDatabase instead. CompactDatabase performs compact and repair at the same time.
Use the DBEngine.CompactDatabase.
In access 2000 you can also see that the Compact and Repair are merged together.