Access Connects to SharePoint 2010

SharePoint Enterprise 2010 includes Access Services, a new SharePoint feature for hosting Access databases and their associated applications on SharePoint. Access Services may be a good approach for organizations where users who need to use an Access application do not have Access installed but do have a Web browser and connectivity to SharePoint. Due to limitations in the Access features supported, Access Services will not work well with many existing Access databases and applications. However, developers may want to evaluate the feature, especially those deploying new databases in an environment where Access is not available or a Web user interface would be preferable.

Access for Web Applications Using SharePoint

Traditionally used for small departmental database applications, Access has long allowed data storage directly in SQL Server, and Access 2007 introduced data storage in SharePoint. However, until now, all Access applications required Access or the redistributable Access runtime engine as well as the Access application code to be installed and maintained on their PCs. This limited the reach of Access applications and increased the overall total cost of ownership.