switch off compact on close

boerbende · Dec 25, 2014

Hello,

I am using Access 2010.
Under options, current database I have DESELECTED "compact on close"
Still all my databases are compacting on close. How can I prevent Access to compact on close?

Problem is that we work under Citrix and sometimes things happens with Citrix that they have to reboot all the servers. The databases tries to close and compact and don't get enough time, so I get mdb copies.
Besides I recently had only the compacted database1.mdb while my file Name.accdb was gone, so again the compact was wrong.

Many thanks

Ben

burrina · Dec 25, 2014

It can't compact unless you tell it too! Is it losing a connection to the back end?
You mat wan to have a hidden form load when the db loads so as to maintain a connection.

boerbende · Dec 25, 2014

It's as simple as that. No backend, just several accdb's which have the same problem. And I tell them not to compact, but still they do it.

I will try to exclude Citrix first by the way, it's not the first time applications under Citrix shows different behaviour.

boerbende · Mar 12, 2015

Found the solution:
Indeed the "compact on close" does not do the job alone.
Microsoft has another hidden option which compacts on close

Under File, options, Current database switch off: "compact on close".
Under File, options, Current database switch off: "Use the cache format that is compatible with 2010 and later".

Ben

battles · Oct 17, 2019

boerbende said:
Found the solution:
Indeed the "compact on close" does not do the job alone.
Microsoft has another hidden option which compacts on close

Under File, options, Current database switch off: "compact on close".
Under File, options, Current database switch off: "Use the cache format that is compatible with 2010 and later".

Ben

Thanks, Ben! Saved me a tons of hair pulling! :banghead:

boerbende · Oct 26, 2019

battles said:
Thanks, Ben! Saved me a tons of hair pulling! :banghead:

Glad I could be of any help.

isladogs · Oct 26, 2019

boerbende said:
Found the solution:
Indeed the "compact on close" does not do the job alone.
Microsoft has another hidden option which compacts on close

Under File, options, Current database switch off: "compact on close".
Under File, options, Current database switch off: "Use the cache format that is compatible with 2010 and later".

Ben

Sorry to disagree (4 years on...) but the cache options are nothing to do with compacting.
Their purpose is explained in the Access options help file

switch off compact on close

boerbende

Ben

burrina

Registered User.

boerbende

Ben

boerbende

Ben

battles

New member

boerbende

Ben

isladogs

MVP / VIP

Attachments

Similar threads

Users who are viewing this thread