O'Reilly logo

Microsoft® Windows® SharePoint® Services 3.0 Step by Step by Penelope Coventry, Todd C. Bleeker, Bill English, Olga M. Londer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required