allow VBA to compact an open Database
With VBA it is only possible to compact a database when it is not opend. It would be helpful to let VBA copmact the currently opended database like you can do with the UI.
Suggestions related to VBA editor should be posted in the Office Developers User voice site here – https://officespdev.uservoice.com/
It would be nice, like you could do previously (2003 and earlier I believe), to be able to call the command directly in VBA.
That said, workarounds do exist, such as setting the AutoCompact option to True and then having code at the startup that resets it back to False. Pretty easy to implement and does work quite nicely.