Access Office Solutions
When we first created Access Services in SharePoint, we set out on a mission to enable both information workers and developers to quickly create data centric web applications with little or no programming. Over the last several years it has become clear that the needs of our customers have grown beyond the scope of what Access Services can offer, such as mobile device support, integration with line of business data, and professional developer extensions.
When we researched how to close these gaps, the answer became clear as well; we’re aligning efforts behind Microsoft PowerApps as the way to build no-code business solutions on desktop and mobile devices. PowerApps offers a comprehensive set of application building tools, connection to custom web APIs, and a wide array of database options including SharePoint lists, SQL Azure databases, Common Data Service and third-party data sources.
We no longer recommend Access Services for new apps. This feature will be retired from Office 365. We will stop creation of new Access-based apps in SharePoint Online starting June 2017 and shut down any remaining apps by April 2018.
We know that many of you have come to depend on Access custom web apps and we are working to make the transition to PowerApps as smooth as possible. We have added a feature to export your data to SharePoint lists where you can create PowerApps and Microsoft Flows. We have also published guidance on how to port your custom web app to PowerApps here.
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.
Access Desktop databases (.ACCDB files) will not be impacted by this decision. If you’ve used previous versions of Access, these are the databases you’re already familiar with, and you’ll continue to work with files you’ve created in the past. Desktop databases have all the powerful features, such as VBA, that has made Access such a popular way to run a business. We will continue to invest in Access Desktop databases to expanded data connectivity, management, and developer features.