Compact utility

[T Best]

Hey guys, is there anyway to programmatically run the
Compact utility in Access 97?

TIA
Ted

 

[T Best]

also i want to run it on an open database.

 

[Douglas J. Steele]

You can't compact the currently open database programmatically in Access 97.

Take a look at the free TSI SOON (Shut One, Open New) add-in at
http://www.trigeminal.com/utility.asp?ItemID=8#8

 

[T Best]

Is it possible in Access 2000?

You can't compact the currently open database programmatically in Access 97.

Take a look at the free TSI SOON (Shut One, Open New) add-in at
http://www.trigeminal.com/utility.asp?ItemID=8#8

 

[Douglas J. Steele]

See http://www.mvps.org/access/general/gen0041.htm at "The Access Web"

 

[Guest]

I know in Access 2000 and greater there is the option to "Compact On Close".
Look under Tools->Options->General Tab and you will see a checkbox you can
select to Compact on Close.