Stop Access from Compacting on Close

[ilcaa72]

under Options > Current Database i do NOT have "compact on close" selected BUT everytime i close the application, it always compacts. I cant find another setting.

anyway to stop having it db compacted when i close Access.

 

[RuralGuy]

Is it also making a backup at the same time? If so, you may have some corruption. What version are you using? Have you tried a Repair Install?

 

[ilcaa72]

i cant tell if its trying to make a backup... here is the icon i get.

 

[RuralGuy]

What version are you using?

 

[JHB]

under Options > Current Database i do NOT have "compact on close" selected BUT everytime i close the application, it always compacts. I cant find another setting.

anyway to stop having it db compacted when i close Access.

Do you've some code running that you're not aware of?
If you open another database, does that compact on close?
What if you create a new database and close it, still compacting?

 

[arnelgp]

you can disable it through VBA:

Application.SetOption "Auto Compact", False