Let’s say that you configured your Microsoft Access database
with special startup options that prevent users from using any database object
except the user form and custom menus. Upon startup, Access takes the user
directly to the user form.

Now you need to make changes to the database, but in order
to do so, you need to get past the user startup options so you can work with
all objects and menus in the database. Fortunately, Access has a number of
shortcut keys that can get you into those objects quickly.

To open the database without opening the user’s startup
form, go to the Windows Explorer and open the MDB file by selecting it and
pressing [Shift][Enter]. (If you see one or more security messages on startup, continue to press [Shift] until you have closed the security messages.) If, after opening it you find that you need a command
that isn’t on the custom menu you developed for your users, press [Ctrl][F11] to toggle back to the default menu bar. Finally, as you work with the database
objects and you find that you need to get back to the Database Window, you don’t
have to minimize or close the windows of the objects you’re working on—just
press [F11] to bring the Database window to the front.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.