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

AFAIK, you'll have to install Acess to get at these repair tools.

>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