Issue while running an update query using Oracle linked server data

[Rajaram]

I m running the below query from ms accesss 2010 and getting error as :
"Operation must use an updateable query."


UPDATE TempTable INNER JOIN D7IP_R5EVENTS ON D7IP_R5EVENTS.EVT_CODE = TempTable.D7i_New SET TempTable.EVT_CODE = D7IP_R5EVENTS.EVT_CODE WHERE NOT TEMPTABLE.D7I_NEW IS NULL

Temptable is local table and D7IP_R5EVENTS is oracle linked server table
that i created in ms access. If i replace the linked server table (D7IP_R5EVENTS) with local table, it works fine.

 

[jdraw]

Is this D7IP_R5EVENTS.EVT_CODE the PK of the Table?

You may find something here http://allenbrowne.com/ser-61.html

 

[Rajaram]

yes it is the primary key. I figured out that the Unique Identifier need to be selected while creating linked table from MS Access. I fixed it and it works well now. And you also caught the point. Thanks

 

[SOS]

A minor point (and not affecting this directly) but I would replace this:

WHERE NOT TEMPTABLE.D7I_NEW IS NULL

with this

WHERE TEMPTABLE.D7I_NEW IS NOT NULL