=========
QUESTION
———
Is it possible to Compact and Repair a Microsoft Access database from VBA?

 

=========
ANSWER
———
The short answer is no.

HOWEVER – we were lucky enough after much research to stumble across an obscure forum post discussing how to do it via simply sending keys via VBA! See Examples.

 

=========
EXAMPLES
———
[code]SendKeys “%F{TAB}{TAB}{ENTER}”[/code]

 

=========
APPLIES TO / KEY WORDS
———

 

=========
REF
———

 


http://anySiteSupport.com
http://anySiteHosting.com