Integrating Microsoft® Office Access 2007 and Microsoft® SharePoint Server 2007

Section 7. Taking SharePoint Lists Offline with Access

At times, you will want to take your SharePoint lists offline and work with them while you are disconnected from the network. Fortunately, Access 2007 makes this process quite easy. It is important to note that this scenario applies only to Access databases containing links to SharePoint lists (not to imported lists). Here's how you can work with your SharePoint lists offline:

1. Open the database that you want to take offline.
2. Click to select the External Data tab.
3. Click to select Work Offline from the SharePoint lists group. The icons associated with the linked tables change to appear as in Figure 27.

   Figure 27. The icons change to indicate that you are working offline.

Synchronizing Your ...