Board index » Visual Studio » DBEngine.RepairDatabase

Visual Studio245
Hi,



I tried using some old routines for repairing and compacting an Access

database and got err msg "Error 3251: Operation is not supported for

this type of object".



OS was & still is Win2000

VB6 before & now



Was Access V8 now Access V9.



Old project used DAO 3.51 and DBEngine.RepairDatabase was a available.

Now I'm using DAO 3.6 and DBEngine.RepairDatabase is not there when I

look in the object browser.



Can anyone advise if it is still possible to repair a database from VB

and if so how?



Regards Moggs





*** Sent via Developersdex www.developersdex.com ***

Don't just participate in USENET...get rewarded for it!


-

Moggs,

Now when you .CompactDatabase you are also repairing

the database too, if it necessary. Oddly enough if you

Repair a database when it doesn't need it it can cause

damage so the two fucntions were combined, without

renaming it, into .CompactDatabase so the repairs are

made if needed.



mike



-