Access: Create a switchboard item that closes down Access 2003/XP/2000/97

Also learn how to create a switchboard item that closes down Access 2007.

Question: In Access 2003/XP/2000/97, how can I create a command on the Switchboard that exits out of Access? I've tried the "Exit Application" in the Switchboard Manager, but this only closes down the database that I have open...it does not close down the Access application.

Answer: There are a number of ways to create a Switchboard Item that closes Access. We'll demonstrate one solution.

First, create a new macro in Access. Then select "Quit" as the Action, and "Prompt" as the Option.

We've saved our macro as MacroQuit.

Next, open the Switchboard Manager. You can do this by selecting Database Utilities > Switchboard Manager under the Tools menu.

Finally, select the "Run Macro" command and select "MacroQuit" as the Macro. Click on the OK button.

Now you should see a Switchboard Item called "Exit". When you select this option, it should shut down Access for you.