>Is there a way to Compact a database on exit? I thought there was but can't seem to find it?
>
>TIA
Anywho, with A2K it is a DB option to compact on exit. Go to Tools->Options and check "Compact on Close".
For A97 look at TSI SOON freebie at
http://www.trigeminal.com/utility.asp?1033, or you could build a VB exe that does this from a batch file.
HTH