Microsoft Access 2010 Bible

Part V: Access and Windows SharePoint Services

1150

Access builds a link for each table to the newly created SharePoint list (see Figure 35.7).

FIGURE 35.7

The local tables are replaced with links to SharePoint lists.

The table shown in Figure 35.7 is hosted in SharePoint as a standard SharePoint list. As discussed

previously, working with this data in Access is no different than using a linked SQL Server table,

except this same table is available to authorized SharePoint users, as shown in Figure 35.8.

The formatting in Figure 35.8 looks strange because the Features column is a memo field contain-

ing a lot of data. You can resolve this minor issue by adjusting the column width and height in

SharePoint (a process not described here).

The data in the SharePoint list is fully editable. Authorized users can change existing rows, delete

existing rows, and add new rows. Access users see the changes in SharePoint when their data-

sheets, forms, and reports are refreshed.