Recent content by 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 :-)

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...