Operation must use an updatable query - Access Interface with SQL Server table VIEW

[stalk]

Any thoughts how to resolve Operation must use an updatable query.
I clicked on help and found this link which is of no help..




https://docs.microsoft.com/en-us/off...6)%26rd%3Dtrue

[ranman256]

depending on the joins, you cannot update a table. some will, some wont.
also
you cannot update using the SUMMATION TOTALS on.

[Gicu]

Is your SQL view updatable in SSMS? If it is then you can make it updatable in Access (assuming you link it in) by creating a "pseudo" primary key :
CurrentDb.Execute "CREATE INDEX PrimaryKeyIdx ON TableName (YourPKField) WITH PRIMARY"

https://www.access-programmers.co.uk...access.157981/
Cheers.

[stalk]

No summary fields in view or Access table.

I have limited control on the SQL view which is READ-ONLY and NOT up datable from Access link

I don't want to create primary key on my access table (accdb) it will mess up the existing work flow which is depending on the unique key which is a combination of 3 fields.

I tried copy pasting the view as local table and it worked, I was able to update the field in Access. But I can't re-create the view as local table 10 times a day.

Any other thoughts?

[Gicu]

Not sure I follow you. Do you want to update the SQL view (linked) in Access or do you want to import it and have it as an Access table. The link is not updatable because it doesn't have a primary key; if you use the "Create Index" statement (you can do it on your three fields https://docs.microsoft.com/en-us/off...oft-access-sql) you should become updatable. If instead you want to use it as a local table you can simply import it but you would loose previously updated data.

Cheers,