Microsoft Access 2010 Bible

Chapter 33: Integrating Access with SharePoint

1123

FIGURE 33.6

The SharePoint calendar displaying the event scheduled in the Access table

Note
Rather than requiring the user to log in each and every time she uses SharePoint data, after a user’s SharePoint
credentials have been established, Access creates a UserInfo table containing information about the user and
her role in SharePoint. Although the user has to provide a password to initially access SharePoint, the UserInfo
table is a repository of additional information about the user. The UserInfo table resides within Access, which
means that it’s available before the user logs in to SharePoint. This enables Access to provide SharePoint with
the user information as the user logs in to SharePoint.

Exporting Access tables to SharePoint

Sometimes you need to transfer data from Access to SharePoint so that SharePoint users have

access to the same data as Access users. The first example exports a table from Access to

SharePoint:

1. Open the Chapter33.accdb example database.


2. Open the tblCustomers table, or just highlight tblCustomers in the Navigation
   Pane.

When you open the table, the Access ribbon changes by adding a few more controls.

3. Select the More drop-down list in the Export group on the ribbon’s External Data tab and
   click SharePoint List (shown in Figure 33.7).