Operation must use an updateable query

[davea300]

Hi

I'm getting the error in the title of the post whilst trying to run the query below:

UPDATE GAS_SURE_NEW INNER JOIN STODBA_JJSDATE ON GAS_SURE_NEW.jjobno = STODBA_JJSDATE.JJOBNO SET STODBA_JJSDATE.JSDATE = [GAS_SURE_NEW].[jcompdate]
WHERE (((STODBA_JJSDATE.JSTATUS)="3"));

The JJSDATE table is linked via ODBC in access 2007 and I've updated fields in it before. I suspect the inner join has something to do with it. Any ideas?

 

[RainLover]

The Joins would most likely be the problem.

Change them in the Query grid rather than retype them. You should be able to work it out there as you already have suggested a solution.

WHY DO YOU USE CAPS. TOO MUCH OF IT MAKES IT DIFFICULT TO READ. YOU CAN READ IT BECAUSE YOU KNOW WHAT IT IS SUPPOSED TO SAY BUT US POOR SOULS WHO ARE TRYING TO HELP FIND IT DIFFICULT TO READ.