Bypass startup options when you open a database

If you used the Access Options dialog box, created an AutoExec macro, or created an Open event procedure to specify what happens when you open a Microsoft Office Access database, you can bypass those settings to regain full access to your database.

What do you want to do?

Bypass startup options

View bypassed options

Bypass startup options

To bypass startup options, do the following:

  • Hold down the SHIFT key while opening your database.

Note: Depending on the macro security settings for your database, you might see one or more security messages on startup. You must hold down the SHIFT key until you close the security messages, or the startup options will not be bypassed.

Top of Page

View bypassed options

When you open a database while holding down the SHIFT key, many of the options that you set on the Current Database page of the Access Options dialog box are bypassed. To view these options, do the following:

  1. Click the Microsoft Office Button Office button image , and then click Access Options.

  2. Click Current Database.

The following table lists each of the settings on the Current Database page and how they behave when you open the database while holding down the SHIFT key.

Option Group


Behavior when startup options are bypassed

Application Options

Application Title

The custom application title is not displayed.

Application Icon

The custom application icon is not displayed.

Display Form

The designated form is not displayed, and none of the form's event procedures are run.


Display Navigation Pane

The Navigation Pane is displayed regardless of the setting.

Fluent Ribbon and toolbar options

Ribbon Name

The designated custom Fluent Ribbon is not displayed.

Allow Full Menus

All default Fluent Ribbon tabs are displayed regardless of the setting.

Allow Default Shortcut Menus

All default shortcut menus are displayed regardless of the setting.

Note: If you add an Access macro named AutoExec to a database, the macro normally runs each time that you open the database. When you bypass the startup options, the AutoExec macro does not run.

Tip: To prevent users from bypassing startup options, disable the Bypass (SHIFT) key by using Visual Basic for Applications (VBA) code to set the AllowBypassKey property of the database. For more information about setting the AllowBypassKey property, click the link in the See Also section of this article.

Top of Page

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.