I use Office 2010 and found this command
DoCmd.RunCommand acCmdCompactDatabase
But doesn't look like this can be ran from a form button or macro.
Error: You cannot compact the open database by running a macro or Visual Basic code.
Matt
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.