Can anyone tell me how to run the Compact Database tool from my VBA code. I current do docmd.RunCommand(acCmdCompactDatabase) but it pops up a window wanting to know which database I want to compact. Is there a way to automate this within the current DB so there has to no user input.
Thanks
Chad