SPO list lookup value cannot be edited in linked Access table

JosephNierenberg 

You can't change the design of linked tables from Access, but you should be able to change the values in a linked table.

Lets look at an Access application that's linked to two SharePoint lists: Product and ProductGroup. ProductGroup is a lookup table for Product in SharePoint. In Access you can add a new ProductGroup while the linked table is opened:

After adding, the new group can be selected from Product:

And when you selected the product group and go to the next record, the group description and packaging instruction are filled in automatically:

You can also change values in de ProductGroup table. Lets say we want to change the temperature instruction for Ice cream and set it to 20 degrees:

Now when you enter a new record in Product, the changed instruction is filled in. The instruction for records that where already in Product are not updated. If you want these to update as well, you just reselect the product group and the changed instruction is filled in (when you confirm the change, for instance by moving to another record).

Hope this opens up things for you.

Best wishes,

Tieme