Microsoft Access 2010 Bible

Part V: Access and Windows SharePoint Services

1130

Export issues are reported in a table named Move to SharePoint Site Issues, with one row for each

problem (a single Access field may generate multiple rows in the issues table). Most export prob-

lems are traceable to data incompatibility issues, but other situations exist.

For instance, while exporting the tables in Chapter33.accdb, a Duplicate output desti-

nation ‘Title’ error was reported on tblCustomerContacts, and the export failed. None

of the tables in this database were exported to SharePoint because of the error. It turns out that this

error occurred because Title is a reserved word in SharePoint. Every custom list in SharePoint

includes a Title column that cannot be deleted or renamed, making it impossible to add a second

column named Title in a list.

Figure 33.14 shows the tables copied from Access to the SharePoint site. The tables and their data are

now stored and managed by SharePoint Services. All that is left in the Access database are logical

links to the SharePoint Web site. The tables and data are no longer stored in the Access database.

FIGURE 33.14

Tables added from Access to SharePoint

Exported Access tables

During the export process, several fields are added to the SharePoint list that are required for list

management on the SharePoint side. These fields are available in the linked table in Access, but are

not included in any of the queries, forms, or reports based on the table before it was exported to