January 23, 2007
What’s new in Microsoft Access 2007 - Publish to SharePoint
Access has had a feature to “Upsize to SQL Server” for quite some time, and the “Move to SharePoint” feature in 2007 is very similar. It creates SharePoint lists for all the data, moves the data to those lists, and replaces the local tables in the database with remote tables linked to the newly created lists.
And then here’s information from Microsoft’s website on Access 2007…
Introduction to integrating data between Access and a SharePoint site
You can share and manage data in many ways by using Microsoft Office Access 2007 with Microsoft Windows SharePoint Services 3.0. You can benefit from the collaboration features of a SharePoint site while continuing to use the data entry and analysis features of Access. For example, you can track versions of data, subscribe to alerts so that you know when changes are made, and manage permissions for the data.
Ways to work with data
When you use Office Access 2007, you can share, manage, and update data from SharePoint sites in several different ways. More on What’s new in Microsoft Access 2007 - Publish to SharePoint
