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