| Working with Windows SharePoint Services Microsoft Office Access 2007 is deeply integrated with Windows SharePoint Services to offer a Web-based user interface, alerts, revision history, RSS feeds, a Recycle Bin, and central IT manageability. To take advantage of the capabilities offered by Windows SharePoint Services, you must move your data to the server and create a link between each Access table and the Windows SharePoint Services lists.
To move data to Windows SharePoint Services: 1. Close all open objects in Access. 2. On the External Data tab, click Move to SharePoint. 3. Type the URL of a site to which you have editing rights, and then click Next. If you want to save a copy of the Access data, click Browse, and then select a document library. Access creates a Windows SharePoint Services list for each Access table.
After your data moves to Windows SharePoint Services, you cannot change the table schema in Access. You must modify the Windows SharePoint Services list. For quick access to the list from Access, right-click the orange table icon, and then on the SharePoint List Options shortcut menu, click Open Default View.
|