Microsoft Access 2010 Bible

Part V: Access and Windows SharePoint Services

1160

FIGURE 35.16

The online help for compatibility issues is quite comprehensive.

Repairing the error caused by the OLE Object fields in tblProduct (Picture_Small and

Picture_Large) is easy. For this example, the data type of each of these fields was changed to

Text, but in a production environment you’d probably want to convert these fields to the

Attachment data type and add the product picture to these fields.

The relationships issues are a bit different, and more complex, that simple data type incompatibili-

ties. On the SharePoint side, relationships are managed as lookups from one table to another. Using

the relationship between tblCustomers and tblSales as an example, first delete the relation-

ship between these tables in the Relationships window (opened from the Database Tools ribbon

tab). Next, open tblSales in design view and change the data type of the CustomerID field from

Number (Long Integer) to Lookup Wizard, which opens the Lookup Wizard dialog box (see Figure

35.17).

You specify the source table for the lookup field in the next Lookup Wizard screen (shown in

Figure 35.18). In our case, we specify tblCustomers as the source of the CustomerID field.