Error when using large linked SharePoint list in Access web app

Symptoms

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.

Cause

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

Resolution

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.
Properties

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

Feedback