Disabling "Compact on Close" During Testing

[Guest]

I have several databases where I've set the "Compact on Close" option. They
are big enough that the compact process takes a couple minutes. Anybody know
an easy way, other than turning off that option altogether, to bypass the
compact when I'm doing some testing that involves opening and closing the
database repeatedly? I'm hoping there's some keyboard combination that will
do it, similar to bypassing an Autoexec macro by holding down the shift key.

 

[John W. Vinson]

Anybody know
an easy way, other than turning off that option altogether

Turn it off altogether and leave it off, would be my suggestion. It's a nice
idea but in practice it often does more harm than good.

Any multiuser database should be split in any case - and you don't need to
compact a frontend, and you can only compact the backend when nobody's using
it anyway.

John W. Vinson [MVP]