I'm trying to do an update query on a table. I want to update only a
subset of the rows, so I am joining the table against a non updateable
query which contains values for the items in the table that I want to
update.

The SQL looks something like this:


UPDATE table INNER JOIN query
ON table.field=query.field
SET table.field2=constant

I am NOT trying to update any items in the query, only the items in
the table. In spite of that, Access gives me the "Operation must use
an updateable query" error.

I am aware that I could change the non-updateable query to be a
make-table query, but I'm looking for a better solution than that if
it exists.

Thanks