in Access2000 and newer, you can set a db to compact automatically when it
closes.
open the database window.
on the menu bar, click Tools, Options.
on the General tab, checkmark the box next to Compact on Close.
hth
Ken said:
Is there VBA code I can use when quiting my application that will compact
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.
