Stop Access from Compacting on Close (1 Viewer)

I

ilcaa72

Registered User.

Local time

Today, 13:01

Joined

Nov 27, 2016

Messages

38

• Aug 12, 2017

• #1

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

AWF VIP

Local time

Today, 11:01

Joined

Jul 2, 2005

Messages

13,826

• Aug 12, 2017

• #2

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?

 

I

ilcaa72

Registered User.

Local time

Today, 13:01

Joined

Nov 27, 2016

Messages

38

• Aug 12, 2017

• #3

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

 

RuralGuy

AWF VIP

Local time

Today, 11:01

Joined

Jul 2, 2005

Messages

13,826

• Aug 12, 2017

• #4

What version are you using?

 

J

JHB

Have been here a while

Local time

Today, 19:01

Joined

Jun 17, 2012

Messages

7,732

• Aug 13, 2017

• #5

ilcaa72 said:

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.

Click to expand...

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

..forever waiting... waiting for jellybean!

Local time

Tomorrow, 01:01

Joined

May 7, 2009

Messages

19,230

• Aug 13, 2017

• #6

you can disable it through VBA:

Application.SetOption "Auto Compact", False

Click to expand...