enable/disable compact and repair via vba?

[Spidy6123]

Hey,
I was wondering if there's a way to enable/disable the compact and repair option via vba?

this doesn't seem to be working..
CommandBars("Menu Bar").Controls("Tools").Controls("Options").Controls("General").Controls("Compact on Close").Enabled

Any help is much appreciated.

TIA

 

[Spidy6123]

Thanks anyways guys.. found it

Application.SetOption "Auto Compact", True


Cheers

 

[missinglinq]

Be aware you should always do a backup before compacting! Compacting sometimes causes corruption to raise its ugly head!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[Spidy6123]

Exactly why I'm controlling it via VBA.. it was being compacted on a network drive and failing..

I have now implemented logic so that the database will not run on the network drive.. (SQL backend so the access frontend is mobile)

Thanks for the good advice