Compact all mdb files in directory

QB · May 6, 2009

How would I go about looping through all the mdb files in a directory and
performing a compact and repair on each of them?

Thank you,

QB

Alex Dybenko · May 8, 2009

Hi,
to loop through all mdbs you can use Dir() function, and to compact each -
use dbengine.CompactDatabase method

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com