Access.2007.VBA.Bibl..

(John Hannent) #1

  1. Click the Navigation Options button to open the Navigation Options dialog, where
    finally you can check the “Show System Objects” checkbox, as shown in Figure 14.4.


FIGURE 14.4
Checking the “Show System Objects” checkbox on the Navigation Options dialog.


  1. Click OK to close the Navigation Options dialog, and again to close the Access Options
    dialog.


In the Tables section of the Navigation Pane, you will now see a number of system tables, starting
with the prefix MSys, and displayed in a dimmed font (Figure 14.5). If you imported the
USysRegInfo table from another database, you will see it there too, although curiously, it is not
dimmed.


You don’t have to do anything special to make the USysRegInfo table a system table; a table with
this name is automatically categorized as a system table. If you are creating the table from scratch,
refer to Table 14.2 for a listing of the necessary fields and their data types.


Creating Access Add-ins 14

Free download pdf