Microsoft Ending Access Services for SharePoint Online -- Redmondmag.com

Microsoft Ending Access Services for SharePoint Online

By Kurt Mackie
04/04/2017

Microsoft plans to end Access Services for SharePoint Online, starting in June.

Access Services is a means for building SharePoint applications using the Microsoft Access database management system. The applications created using Access Services become accessible in a Web browser.

It's possible to use Access Services with SharePoint Server 2013 and SharePoint Server 2010, and Microsoft even added new capabilities to Access Services with the release of SharePoint Server 2016. It will still be possible to use Access Services with Microsoft's supported SharePoint Server products, as well as future server releases, Microsoft promised, in its announcement:

We will include Access Services and Access Web Apps in the next version of SharePoint Server. Access Web Apps and Access Services will continue to be supported in all current versions of on-premises SharePoint servers for the remainder of the product lifecycle.

However, Access Services support will be ending for SharePoint Online. The ability to create new Access apps for SharePoint Online will end in June 2017. Microsoft will shut down any created apps by April 2018, according to the announcement.

Microsoft is pointing SharePoint Online users of Access Services to instead build their applications using PowerApps and Microsoft Flow. PowerApps is Microsoft's template-driven application creation solution, while Microsoft Flow is a workflow automation creation tool frequently compared to the IFTTT mashup service.

The announcement claimed that the transition to PowerApps has been eased somewhat by a new feature Microsoft added. It lets users export Access Web app data to SharePoint Lists, as described in this support document. It's also possible to export Access Web app data to an Access desktop database, as described here. A third approach is to migrate Access Web app data to SQL Server, according to Microsoft's "Access Services in SharePoint Roadmap" document.

Microsoft recently announced a downloadable document for SharePoint Online users that's designed to take them through the steps of using PowerApps, Microsoft Flow and Power BI. In addition, Microsoft promised that future help will be arriving for SharePoint Online users who are struggling with Access Services conversions.

"In the coming months, we intend to share any tips/tricks/gotchas discovered while assisting customers through this time of transition exporting their data and finding replacement solutions," a recent TechNet blog post claimed.

Microsoft's feature deprecation announcement doesn't pertain to Access database files. It just concerns Access Services for SharePoint Online.

Microsoft Most Valuable Professional Vlad Catrinescu early on noted the deprecation of Access Services for SharePoint Online. He added that Microsoft's pledge of support for Access Services with the next SharePoint Server release was "another proof" that Microsoft's server product plans are still continuing.

About the Author

Kurt Mackie is senior news producer for 1105 Media's Converge360 group.

Featured

Using Configuration Files to Control PowerShell Scripts, Part 2: Building Blocks

Learn how to use PowerShell's GUI capabilities to dynamically create configuration files that enhance script flexibility and usability.
U.S. House Leaders Unveil Bipartisan Strategy for AI Governance and Innovation

On Tuesday, U.S. House Speaker Mike Johnson and Democratic Leader Hakeem Jeffries received the final report from the bipartisan House Task Force on Artificial Intelligence, which outlines essential principles and recommendations to bolster American leadership in AI.
Using Configuration Files to Control PowerShell Scripts, Part 1: The Basics

Learn how to use JSON configuration files to make PowerShell scripts more dynamic, flexible and user-friendly.
Exchange Online Receiving Enhanced Message Trace

Microsoft has announced the public preview of its enhanced Message Trace feature in the Exchange admin center (EAC) for Exchange Online.
Major Microsoft Multifactor Authentication Vulnerability Revealed

A vulnerability in Microsoft’s multifactor authentication (MFA) system has been uncovered by cybersecurity firm Oasis Security, allowing attackers to bypass security measures and access sensitive data across services including Outlook, OneDrive, Teams and Azure.