totn Access

MS Access 2003: Create a switchboard item that closes down Access

This MSAccess tutorial explains how to create a switchboard item that closes down the Access program in Access 2003 (with screenshots and step-by-step instructions).

Question: In Microsoft 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.

Microsoft Access

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.

Microsoft Access

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

Microsoft Access

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