VBA Compact repair all databases in a folder

[mahmed1]

Hi

Is there a vba code I can use that opens up each access dB in a folder and does a compact and repair) and then closes the db

I am trying to run this every week to keep my databases clean and lean

 

[mahmed1]

I can run from excel too

for each dB in dbfolder
open dB
Compact repair
Close dB
Next dB

Some like this

 

[alansidman]

Find all Access databases, and Compact and Repair

I'm trying to find all Access databases in a directory and Compact and Repair each without opening Access each time. I found the following article explaining how to find them and write to a file: B...

stackoverflow.com