=========
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
———