Compacting database on Exit

[Malcolmneill]

I am trying to compact a DB when exiting the application, but the code that was posted by Ghudson doesn't seem to work. I am sure it's my problem, but I am wondering if it's because the DB is a linked database. So for this VBA novice, although I understand the code from my old programming days, I am not sure about all the syntax and built in functions, so is the CurrentDb.Name entry the "name" of the application or the Database?

 

[speakers_86]

Check out Aphrodite in the sample databases forum. Look at frmSettings, tab called Options 2, and see the code behind the check box labeled compact on close.