-
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.