Microsoft® Windows® SharePoint® Services 3.0 Step by Step

Linking an Access 2007 Table to a SharePoint List

Data were copied in the previous two sections so that the same data could be stored in both an Access 2007 database and on a list on a SharePoint site. However, no data synchronization between these two data locations occurred. If you do not want to maintain two copies of that data but do need to refer to the data within Access 2007, then Access 2007 provides methods of accessing external data that are physically located outside an Access 2007 database. The easiest way to externally reference a SharePoint list is to use linked tables, which were known as attached tables prior to Microsoft Access 95. A linked table stores only a connection to the SharePoint list. You should use linking rather than ...