Avatar of KP_SoCal
Flag for United States of America

asked on 

Access Query Error: "Operation must use an updateable query."

Not sure what I'm doing wrong on this update query.  

UPDATE tblMaster INNER JOIN tblPricing 

ON (tblMaster.fldSeries = tblPricing.COSER2) 
AND (tblMaster.fldMdlYr = tblPricing.COMDLYR) 
AND (tblMaster.fldPIO = tblPricing.COACCE) 

SET tblMaster.DlrCost = [tbl].[CODCTL];

Open in new window

Instead of it running, I get an error message "Operation must use an updateable query."  Any ideas on what I'm doing wrong or a way around this?

In my query, 'tblPricing' is a read-only table, but the 'tblMaster' (the one I'm trying to update) allows updates and edits.  Not sure if this information holds the key in solving my problem, but I at least wanted to present it.

Thanks for any help!
Microsoft AccessSQL

Avatar of undefined
Last Comment

8/22/2022 - Mon