>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