Close button without compacting

[Harley]

The database that I currently work with has the option chosen to compact and repair on close so that if I am not present when there is trouble the users can close the db and the problem is usually corrected. I currently have a close button on the Main switchboard that closes the db. Is there a way to make a button or another way that will close the db that will by pass the compact and repair choice? I know that I can use task manager, but that usually creates db1, db2 and so on.
Thanks,

 

[KeithG]

You could make a button to set the compact on close property to false and then close the database. If you use this approach you would also want to add code to you startup form to set the compact on close property to true if it is false.

 

[Harley]

Do I need to use VB? I am not very good at creating VB. I can sometimes modify it. Thanks for your idea.

 

[RuralGuy]

Here's a thread that might give you some ideas. Public Function CompactOnClose()