Access.2007.VBA.Bibl..

(John Hannent) #1

  1. On clicking OK, you will get the Link Tables screen, shown in Figure 18.62, where you
    can select the tables to link to the Access front end.


FIGURE 18.62
Selecting SQL Server tables to link.


  1. If one or more of the tables lacks a unique index, you will get the Select Unique Record
    Identifier message (Figure 18.63). Select one or more fields to create a unique index and
    click OK to proceed.


FIGURE 18.63
Selecting fields for a unique record identifier index.

Part III Adding More Functionality to Office

Free download pdf