I have an Access 2010 application that runs on a busy network (separate front/back ends, same version of Access). Lately when I close it, the compaction utility runs. It's just as if the option was checked for "compact on close." But that option is not checked, neither on the back-end database. I inherited this application, and it started showing this behavior only recently. I know the VBA code and there is no compact routine (I searched on `compact` in the modules to make sure). The compact happens even if I run `Call SetOption("Auto Compact",False)` when unloading the main form. The compact also happens if I disable VBA by not clicking on "Enable Content".I have heard you can launch Access with command-line parameters to get this behavior, but that isn't the case here.I have also run decompile/repair maintenance, but no change. Why does the database compact on close?
