Operation must us an updateable query

[David9746]

I have an update query with 2 tables joined by a Key field. One of the tables
is a linked table from an sql server and the other table resides locally in
the database.

I am trying to update the local table with the data from a field in the
linked sql table but i keep getting the error message "Operation must us an
updateable query."

Strange thing is this query was imported from another database and it is
using copies of the same local table and yet it works fine in the other
database with the same linked sql server table.

I don't know why since the table it is trying to update is not opened read
only nor is the databse opened read only.

I would appreciate any thoughts on this.

Thanks
David

 

[NTC]

an updateable query is a state unto itself - and doesn't mean the table or db
is read only

the table/db may be read only if you have Access2007 and have not
established the Trust location.

any query may be not updateable if the database considers the join/design to
be able to apply an update to multiple records. rather than import this
query....copy/reuse the same front end where it is known working.... or if
that is not possible; search on the topic of updateable queries - you will
see good advice on this issue.