I have a reoccuring problem that keeps coming up with update (and delete/append) queries. Anytime I try and tie the table I am trying to update to a list of records I get a message that says "Operation must use an updateable query".

For example:

UPDATE DISTINCTROW TblBaselinePriceFile INNER JOIN qryCrossFacilityMissingPricesMissingNDC ON (TblBaselinePriceFile.MPM_NDC = qryCrossFacilityMissingPricesMissingNDC.NDCCurrent ) AND (TblBaselinePriceFile.MEM_IK = qryCrossFacilityMissingPricesMissingNDC.MEMIK) SET TblBaselinePriceFile.BaselinePerUnitCost = [resolvedprice];


Any suggestions on how to solve this issue? Thanks in advance for your help

Queries that have joins on them are not updateable. What you have to do is make the joined query into a make-table query that outputs data, then perform the update on the new table. You cannot do "both at once." Silly, huh?


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division