Microsoft Access 2010 Bible

Chapter 33: Integrating Access with SharePoint

1129

At the conclusion of the process, all the tables in the Access database have been moved to

SharePoint and linked back to the Access application (see Figure 33.13). Notice that the icon next

to each table name has changed to indicate that the table is now linked and not contained locally.

Just as with other export processes, you are able to save the export steps for future use. Access also

makes a backup of the Access database file prior to the export process so that you can revert to the

prior state, if necessary.

FIGURE 33.13

After executing the Export to SharePoint Wizard, tables are linked from Access to SharePoint.

Tables linked

to SharePoint lists

The icons indicating linked SharePoint lists look very much like Access table icons. Each linked list

is accompanied by an arrow, and the color of the icon has changed to a yellowish-orange color.

Otherwise, the icons look much like any linked table.

All of the queries, forms, and reports are based on the linked tables and should function as before,

with a few exceptions. Because of incompatibilities between Access and SharePoint data, not every

Access data type migrates to SharePoint. The incompatible fields are created in the SharePoint list,

but they are added to the SharePoint list as text columns and are left empty.