Configuring Access Services with SharePoint 2010

Access 2010New in SharePoint 2010 Enterprise is Access Services along with a set of pre-defined web database templates that demonstrate this new capability.   This feature allows an Access 2010 user to create simple database solutions that include tables, forms, queries and reports and then publish them into SharePoint 2010 as a web site.

Access Services has a dependency on SQL Server 2008 R2 Reporting Services (SSRS) for rendering the Access database reports.   If you have not properly installed and configured SSRS and the SharePoint Reporting Services add-in you will get an error when trying to view any report in your Access database web solution.

Read this TechNet article for detailed steps on configuring SSRS for SharePoint 2010 integration.

If you have already installed SSRS with SharePoint Integration and are still experiencing errors when viewing the Access database reports you may have not fully configured the Reporting Services Add-in. 

The following error may indicate that the Reporting Services Add-in was not configured for connected mode.  

An error has occurred during report processing. (rsProcessingAborted) An attempt has been made to use a data extension ‘ADS’ that is either not registered for this report server or is not supported in this edition of Reporting Services. (rsDataExtensionNotFound)

Connected mode means that your environment contains both the SSRS SharePoint add-in and SQL Server Reporting Services.

Read this TechNet article for step by step details on configuring SQL Reporting Service in connected mode for use with Access Services.

Interested in learning more about Access Services in SharePoint 2010?  Check out this video from the Access Show:  Access 2010 demo of Access Services and web databases.   

Additional Videos:

The Access Show- Restaurant Demo

The Access Show: Client performance improvements against SharePoint lists

The Access Show: How the Microsoft Legal Department Uses Access 2010 Web Databases

The Access Show: Classified ads demo

Access Power Tip: Use the IsClient() expression to conditionally run VBA from Web forms

Leave a Reply