Update table from query

[mladen273]

Hi,



I made a query with which I update table Skenson.
When I click RUN I get the message "operation must use an updateable query.
SQL:
UPDATE q_skenirano LEFT JOIN Skenson ON q_skenirano.[Broj naloga] = Skenson.[Broj naloga] SET q_skenirano.[Broj naloga] = [Skenson].[Broj naloga], q_skenirano.Skenirano = [Skenson].[Skenirano], q_skenirano.Barkod = [Skenson].[Barkod];

What is wrong?

[alansidman]

Look at this thread

http://www.utteraccess.com/forum/Upd...-t1233602.html

[mladen273]

I read everything he writes but I'm not still all too clear.
Can you add here that I am missing.
Please, I need this

thx

[alansidman]

Without seeing your whole db, I cannot fathom what the issue might be. However, if you have one of these issues, then that may be the cause.

http://allenbrowne.com/ser-61.html

Allen Browne lists 14 possible reasons.