Jack said:
Has anyone found a way to 'Compact on Close' in Access97?
There is no setting in 97 for this (I wouldn't use it in later versions
either).
You should be using a split database, in which case you could compact the
backend from the frontend using DBEngine.CompactDatabase (look it up in
help).
As for the frontend, it shouldn't need compacting all that often, but you
could add a 'compact' button to your custom toolbar. Users could hit that
once a week or so.
