By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,573 Members | 907 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,573 IT Pros & Developers. It's quick & easy.

Compact + Repair When Exiting Access Form

P: 37

I have created a Database with several Forms that all have an Exit button at the top.

What I would like is for the database to compact and repair itself whenever the user exits the database?

Do I create a macro? and attach it to a button? If so.....please help.

Many thanks!

Jan 9 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,418
Simply go in tools -> Options -> General and check Compact on close!
Jan 9 '07 #2

P: 37
How simple!
Jan 9 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.