How to find all access apps per site collection in Sharepoint Online

  • Article

Access Services Retirement 

On March 27, 2017, Microsoft announced the retirement of Access Services in SharePoint Online through the Office Retirement Blog.

https://techcommunity.microsoft.com/t5/Office-Retirement-Blog/Updating-the-Access-Services-in-SharePoint-Roadmap/ba-p/57148

We no longer recommend Access Services for new apps and web databases.

  • In SharePoint Server this feature will be supported in accordance with the Microsoft Lifecycle Policy.
  • This feature will be retired from Office 365 and SharePoint Online. We will stop creation of new Access-based apps and Access web databases in Office 365 and SharePoint Online starting in June, 2017 and shut down any remaining apps and web databases by April, 2018.
  • As an alternative to Access web apps and web databases, we recommend that you consider Microsoft PowerApps to build no-code business solutions for the web and mobile devices.
  • I would highly recommend reviewing the following article which has more detail on the deprecation of access services.

How can I find out if I have access apps that will be affected?  

The Sharepoint Online support team has received multiple inquires from customers around an easy way to identify if their site collections currently have Access Apps. Overall there are various ways to determine the Access Apps are hosted on a site collection however to make this process a bit easier I have written a client side object model script to do this for you!

The script will require that you have site collection administrator permissions to all sites within the tenant and the following things installed on your machine.

The script itself can be downloaded at the following TechNet Location: https://gallery.technet.microsoft.com/How-to-find-all-access-8cc8a8c8 

Examples:

.\CSOM-GetAllAccessApps.ps1 -username acktor@salarson.msftonlinerepro.com -SPOAdminURL https://superdomain.sharepoint.com -processSingleSite -URL https://superdomain.sharepoint.com

.\CSOM-GetAllAccessApps.ps1 -username acktor@salarson.msftonlinerepro.com -SPOAdminURL https://superdomain-admin.sharepoint.com -processAllSites