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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
