Must use an updatable query

[GregD]

I have not done a lot of programming in Access over the past two years. I can remember getting this error, but can't seem to remember how to deal with it.

This is a very simple update query which uses two local tables. The 'many' table (tblCleanedRxData) has a primary key. I looked at some an older query where I'm am doing virtually the same thing only the table names have changed. That one runs fine. Both Access dbs are in the same folder. I have read a half dozen threads on this error and most are using more complex queries or remote linked tables. Nothing jumped out at me as to why this is happening.

WTF!

Greg

UPDATE tblCleanedRxData INNER JOIN tblRxDoseUnitsConversion ON tblCleanedRxData.Route = tblRxDoseUnitsConversion.RxName 
SET tblCleanedRxData.Route = [tblRxDoseUnitsConversion].[ConvName]
WHERE (((tblRxDoseUnitsConversion.Type)="Pathway"));

 

[GregD]

Never mind. I removed the 'one' table and changed the query to the following and still got the error. I added the table back and restored the query to its original form and it ran without error.

Grrrrr!

UPDATE tblCleanedRxData SET tblCleanedRxData.Route = 'sdfgsdfg';