>I use Ms. DAO 3.6 object library but I did not find the repair MDB method, anybody can help me please? and also I can not use the following codes to repair and compacting MDB: please help
>
>Dim myDAO36 as DAO.DBengine
>
>Private sub RepairIt
>Dim myMDB as String
>myMDB = "C:\MYMDB.MDB"
>myDAO36.RepairMDB myMDB
>End Sub
>
>Private sub CompactIt
>Dim myMDB as String
>myMDB = "C:\MYMDB.MDB"
>myDAO36.CompactDatabase ....
>End Sub
>
>Thanks and Regards
>Winan
These methods belongs to the DBEngine object:
DBEngine.RepairDatabase
DBEngine.CompactDatabase
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com