Can't update values in a select query

[clancy76]

Hi all - I have a select query that is pulling from two tables - one is a linked SQL Server table, the other is a local Access table. Every time I try to change a value in the query (by just opening the query and typing in a new value), I cannot edit anything. BUT, if I were to take the select query, put it in an update query and run it, the values update fine. Anyone know what I am doing wrong? I tried the usual stuff (see this white paper: https://support.microsoft.com/en-us/...5bed7#bmchange), none of it seems to work. Anyone know what I'm doing wrong?



Thanks!

[Welshgasman]

Any of these apply?
http://allenbrowne.com/ser-61.html

[ranman256]

you cant update in a select query. you update in update queries.
now, if you mean edit fields a select query, SOMETIMES you cant, due to joins in the tables.

depending on table structure, the join will not allow edits. some do.

[clancy76]

Thanks Welsh - yeah all of the typical stuff isn't working. I'm guessing Ranman is right

[clancy76]

Thanks Ran