1

I have been using this process for quite a while and while it is a bit cumbersome it has always worked

SharePoint 2016 Access 2013 Excel 2013

  • Open Access
  • Create ne DB
  • External Data Connect to SharePoint List
  • The Import Excel Spreadsheet into linked list

    I have always been able to import anywhere up to 5,000+ records... Starting today it dies consistently after 1,000 records every time I try with the following error...

    Cannot Update. Database or Object is read-only

  • did you change your list column? – Waqas Sarwar MVP Nov 10 '17 at 22:06
  • When you say it dies after 1000 records, do any of those initial 1000 records get imported? – Gerry Nov 13 '17 at 8:34
1

There are multiple causes of the “Cannot update. Database or object is read-only” issue.

Check if there are lookup columns or metadata columns in the SharePoint list.

Remove the lookup columns from list and then try to update the list items in Access.

If there is TaxonomyHiddenList linked table in the database, it means the list has (had) the metadata columns. Re-create the list without the metadata columns.

Refer to the following article:

"Cannot update. Database or object is read-only" error in linked SharePoint list in Access

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.