How often is too often to compact a MS Access database?
Posted on 2005-04-17
My app creates MS Access databases (.mdb files), which the user populates. An implementation of the app could have as many as 100 .mdb files.
I've automated the compacting process, which runs smoothly, and supports a progress bar. Now I am wondering how often it should be run. Right now, it's every time the user quits the app. There's little or no inconvenience to the user.
But is there a downside to compacting so often? If so, are there any guides to the optimum frequency for compacting?
Advice gratefully accepted.