CODEWITHSUNDEEP
sqlms-access-2010
Couchcommando
Couchcommando

Reputation: 95

Update Inner Join Operation must be updateable query

Trying to update Purchase Order information in the case of Purchase Order revisions.

UPDATE tblPO 
       INNER JOIN qryPOLN_UPDATE_INFO 
           ON tblPO.POLN = qryPOLN_UPDATE_INFO.POLN 
   SET tblPO.[LINE QUANTITY] = [qryPOLN_UPDATE_INFO].[LINE QUANTITY]
 WHERE (((qryPOLN_UPDATE_INFO.POLN)=[tblPO].[POLN]));

Getting the "Operation must be an updateable query" error. Any ideas how to fix?

Upvotes: 0

Views: 627

Answers (1)

Couchcommando
Couchcommando

Reputation: 95

Got it.

I was using a Group By in one of my previous queries. If you put the data into a temp table and run the update off the temp table, gets around the error. Answer was found at https://www.fmsinc.com/MicrosoftAccess/query/non-updateable/index.html

Upvotes: 2

Related Questions