Automatically Compact and Repair Code

[RuralGuy]

Just a thought. Are you sure you have your code in a form that is the last to close when you exit? The symptom could be caused by just closing the form but not closing the db.

 

[Jakboi]

Yup thats it. I have a button on my switchboard which is set to "Exit Application" and has a label I added that says Exit Database.

It works fine like you say when I "X" out the database. It compacts and closes.

When I use the Exit Button on my switchboard it doesnt close Access. I set it using the Tools- Switchboard Manager.

Is there something that can be added to the Command Button Option event tab to make it exit the application like its supposed to. Not sure why its doing this...unless its just an Access thing.

ATTACHMENTS

 

[RuralGuy]

Application.Quit will close/quit Access.