Compact + Repair When Exiting Access Form

[flickimp]

Hi

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!

Imran

[PEB]

Simply go in tools -> Options -> General and check Compact on close!

[flickimp]

How simple!
Cheers