Managing Data with Access and SharePoint 2010

Access 2010 enables interaction with SharePoint 2010 in the following ways:

• Save database as SharePoint— Saving an Access 2010 database to a SharePoint 2010 site stores a copy of the database in a document library on the SPF or SPS server. Users can open a shared read-only master copy of the database or—with Site Member or Site Owner permissions—save a local read-write copy of the database to edit. Changes aren’t saved to the master copy until the user republishes the local copy to the SharePoint server.

• Move table data to SharePoint— Moving (exporting) data to a SharePoint site creates lists that are linked as tables of your database. Access creates a new front-end application that contains the queries, forms, and reports, as well as the linked tables.

• Create an Access database from a SharePoint site— Users who want to take advantage of Access’s editing and reporting capabilities can choose to open a list in a linked Access table and, if the database doesn’t already exist, create a new database to hold the linked table(s) and added form(s) and report(s).

• Export, import, or link a SharePoint list— Access 2010 treats SharePoint lists like other data stores, such as Microsoft Excel, but linked SharePoint lists are editable.