T
T Best
Hey guys, is there anyway to programmatically run the
Compact utility in Access 97?
TIA
Ted
Compact utility in Access 97?
TIA
Ted
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
T Best
also i want to run it on an open database.
D
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
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
T Best
Is it possible in Access 2000?
Douglas J. Steele said: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
D
Douglas J. Steele
See http://www.mvps.org/access/general/gen0041.htm at "The Access Web"
J
Jay
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.
Look under Tools->Options->General Tab and you will see a checkbox you can
select to Compact on Close.