SharePoint 2013 – Access Services

2017-12-11T10:15:27+00:00 June 21st, 2013|Sharepoint|

Overview

Access Services allow users to host Access databases within the context of an Access app. Access apps are a new feature in SharePoint 2013 and these Access apps are built via the Access 2013 desktop client. You can create, edit, and update linked Access 2013 databases and then view them directly from the app. 

You can use Access Services 2010 to view and edit a web database that was created using Access 2010 and SharePoint 2010, and you can republish them to SharePoint Server 2013.  You can’t create a web database using Access Services 2010 in SharePoint 2013, but you can import Access 2010 web databases into an Access app.

Prerequisites

  • SharePoint Server 2013 installed on a Windows 2008 R2 Server or higher
  • SQL Server 2012 Standard or SQL Server 2012 Enterprise

The following SQL Server 2012 Feature Pack Components on the SharePoint server:

  • SQL Server 2012 Local DB
  • SQL Server 2010 Data-Tier Application Framework
  • SQL Server 2012 Native Client
  • SQL Server 2012 Transact-SQL ScriptDom
  • System CLR Types for SQL Server 2012