Update table join linkedtable

[Salmano]

I have an update query like this:

UPDATE tmp_final LEFT JOIN INSTIT ON tmp_final.COD_INSTIT = INSTIT.COD_INSTIT
SET tmp_final.DEN_SCURTA = INSTIT.DEN_SCURTA;

tmp_final is a table created in Access and INSTIT is a linked table (.DBF)
When I run this query, Access asks me "You won't be able to undo the changes this action query is about to make to the data in a linked table/tables. U sure ?", but as you can see from the query I don't update the linked table.
So, how can I skip this question ?

PS: Tools/EditFind/Confirm check boxes are cleared but with no effect... Also, DoCmd.RunSQL has the same effect...

Thank you in advanced.

 

[tlbroadbent]

Try this.

Run DoCmD.SetWarnings Off before the update
and DoCmD.SetWarnings On after. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.