SPO list lookup value cannot be edited in linked Access table

Frequent Contributor

I have a list in SharePoint Online with a lookup table. The list, including the lookup table, works fine in SPO. The list is also linked to Access on my desktop. Access links not only to the list containing the lookup field but also to the list containing the values. The values in the lookup field cannot be edited in Access. The Design View option to edit the values in a lookup field is not available; a help popup notes that the design of the lookup field cannot be changed (to allow or disallow editing) in a linked table. Is that the end of the story? Is there no way to be able to change values from the choices in the dropdown menu, which exist in Access as in SPO?


(Cross-filed in the Access community)

0 Replies