Compacting a DB with VBA or VBScript

[SlakeB]

does anyone know how to compact and repair a DB with either VBA or VBScript?

 

[Remou]

Hi
This may help:
Compact and Repair automatically at the start of each day
faq705-4998

 

[mp9]

Freeware scheduling tool for compacts, repairs and macro runs: Handy Access Launcher (HAL) at

http://www22.brinkster.com/accessory/resources/001.shtml

 

[Eupher]

Hi, SlakeB,

You might also try this:

CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
accDoDefaultAction

Ken S.