Events
Microsoft 365 Community Conference
May 6, 2 PM - May 9, 12 AM
Skill up for the era of AI at the ultimate community-led Microsoft 365 event, May 6-8 in Las Vegas.
Learn more"Access Services reports are not enabled" error when you run a report in an Access 2010 Web database
When you try to run a report in a Microsoft Access 2010 Web database, you receive the following error message:
Access Services reports are not enabled. To view the report, open the report in the Access client.
To work around this issue, create reports by using a client installation of Microsoft Access by following these steps:
- Browse to the Access 2010 Web database site.
- Within the Access 2010 Web database, on the top of the page, click Options, and then click Open in Access.
- The Access 2010 Web database opens in a local copy of Microsoft Access. You can create client reports in the local copy of the Access 2010 Web database.
This issue occurs because SQL Server Reporting Services (SSRS) is currently not enabled for SharePoint Online. SSRS makes it possible to run Access Services reports.
The client reports are located in an .accdb file on the local client. On a local intranet, you can share the folder where the .accdb file is stored so that multiple users can view the reports. You can also right-click a client report and export it to several formats for distribution.
Still need help? Go to SharePoint Community.
Additional resources
Training
Module
Build reports for finance and operations apps - Training
Organizations have a lot of data. When an organization grows, its ability to provide context for all that data becomes increasingly crucial. Reports can organize data in a meaningful way. Finance and operations apps include reporting tools to help you create reports for your organizations, SQL Server Reporting Services (SSRS), Microsoft Power BI, and Microsoft Excel reports. You can use these reporting tools to visualize a data set in many ways, including as a tabular layout with collapsible tables and by u
Certification
Microsoft Office Specialist: Access (Office 2016) - Certifications
Demonstrate that you have the skills needed to get the most out of Access 2016 by earning a Microsoft Office Specialist (MOS) certification.