2

I have a SharePoint list with Lookup columns and metadata(Content type) fields.

I opened the list in Access When I was trying to add new data or edit the data it's saying

"can not update database or object is read-only access".

How to update this list?

1

This error is a known issue in Microsoft Access that occurs when a table is linked to a SharePoint list that has hidden metadata.

All details are described at "Cannot update. Database or object is read-only error in linked SharePoint list in Access"

To overcome this issue try to apply the below instructions:

  1. Link all the lookup columns in the underlying list to tables. as mentioned at “Cannot update. Database or object is read-only”
  2. Disable caching in Access. To do this, follow these steps:

    • In Access, select File > Options.
    • Select Current Database.
    • Scroll down to the Caching Web Service area, and then locate the Microsoft SharePoint tables.
    • Select the Never Cache check box.
  3. Or try to re-create the list without the metadata columns.

| improve this answer | |
  • i followed these steps but still not able to update the list, SharePoint list having hidden metadata columns.So its not possible to update the list from access ? – elina May 25 '17 at 9:13

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.