When you execute update queries against a linked Microsoft SharePoint list, you receive the following error message:
Cannot update. Database or object is read-only.
This problem occurs when the record that you are trying to update contains data that is in a column that exceeds the MaxSize column property that is defined for the SharePoint list.
To fix this problem, determine which columns that contain the records that you’re trying to update exceed the defined MaxSize for those columns. Then, either shorten the data to fit the currently defined size or increase the maximum size of the column in SharePoint. If you make changes to the SharePoint list, you must refresh the linked table in Microsoft Access to reflect these changes. To do this, right-click the linked SharePoint list, select More Options, and then select Refresh List.
Article ID: 3200674 - Last Review: Oct 26, 2016 - Revision: 1
Access 2016, Microsoft Access 2010, Microsoft Access 2013