Automatically Compact DB on Exit?

B

Bernadou

Is there a way I can tell a DB to compact itself when it
is closed by a user?

Thanks!
B
 
S

Scott McDaniel

If you're using Access 2000 or later, you can set the Compact On Close
option. It's in Tools - Options - General.
 

Ask a Question

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.

Ask a Question

Similar Threads

How do I clear a form? 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Bloating? 4
access 2003 crashing 2
Compact back-end database 1
Translate code to French Canadian... 1
Word 2003 won't exit 8
Access 2007 mdb Deletes Self on Compact 3

Top