Automatically Compact and Repair Microsoft Access Databases with Compact On Close

Microsoft Access/Jet databases require routine maintenance to ensure reliability, integrity, and efficiency. You can manually compact and repair a database. However, you can save yourself some time and effort by configuring your database to automatically do this every time it closes. Read the issues and limitations around this Microsoft Access feature Automatically Compact and Repair Microsoft Access Databases with Compact On Close.

3 thoughts on “Automatically Compact and Repair Microsoft Access Databases with Compact On Close

  1. At work I cannot get rid of Compact On Close, even when that option is un-selected. Access version is 2013 or 2016, the latest one. Any advice?

Leave a Reply to Zidar Cancel reply

Your email address will not be published. Required fields are marked *