Microsoft Access 2010 Bible

Chapter 31: Distributing Access Applications

1089

Access only stores one copy of an image (in its original format) and dynamically generates a bitmap

when the image is displayed on a form or report.

Navigation options

The settings in the Navigation section let you define parameters when navigating your database as

an application.

The Display Navigation Pane check box

With most distributed applications, you might never want your users to have direct access to any

of your tables, queries, forms, or other database objects. It’s far too tempting for a user to try to

“improve” a form or report, or to make some minor modification to a table or query. Rarely are

users really qualified to make such changes to an Access database. Deselecting the Display

Navigation Pane option hides the Navigation Pane from the user at startup.

Note
Unless you also deselect the Use Access Special Keys option (described earlier in this chapter), users can press
F11 to unhide the Navigation Pane.

You must close and reopen the current database for this change to take effect.

The Navigation Options button

One nice addition to recent versions of Access is the ability to select which database options are

exposed to users when the Navigation Pane is visible at startup. Clicking the Navigation Options

button opens the Navigation Options dialog box (shown in Figure 31.3), which you use to change

the categories and groups that appear in the Navigation Pane.

FIGURE 31.3

The Navigation Options dialog box