I am afraid this is not an entirely appropriate post for this particular forum, however I am after the database geniuses (i.e. Jeff Mason and David Cameron :D) and these types of people usually avoid MS Access like the plague!

I shall not bore you by duplicating the post here, however if you fancy a nice Access (Jet 3.51) and VB challenge please take the time to read my original post in the Access forum entitled Repairing Corrupted Database in Code.

Please accept my apologies for not posting on topic, however these are desperate times.

Regards
Owain Williams

__________________
Regards
Owain Williams

There are DAO methods which will do what you want. See
http://msdn.microsoft.com/library/de.../D2/S5A2ED.asp and follow your nose for the 'RepairDatabase' and 'CompactDataBase' methods of the DBEngine object.

P.S. I think you should always first repair a database, then compact it, and not the other way around.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com