Error when using large linked SharePoint list in Access web app


Consider this scenario: You have a Microsoft Access web app that contains a table that's linked to a Microsoft SharePoint list. When you try to view this linked table in the Access web app, you receive the following error message:

Sorry, your changes could not be saved. Please refresh your browser and try again.


The SharePoint list is longer than the maximum row number allowed for the listview threshold setting, which is 5,000 rows for SharePoint Online.


Reduce the SharePoint list size to fewer than 5,000 rows, or import the SharePoint list into the Access web app so that it's a local table instead of a linked table.

Article ID: 3211604 - Last Review: 28 Dec 2016 - Revision: 1