I am developing an application in Access 2003. I realize that I can go to the menu item
TOOLS -> Database Utilities -> Compact and Repair Database to compress the size of my application. Is there a way I can accomplish this task by setting up a command button to click. And as a result of the click event, write VBA code that would accomplish the compression.
In other words, is there VBA code equivalent of the Compact and Repair Database action?
Or do you have to manually perform this action?