none
Simple update does not work - error operation must use an updatable query RRS feed

  • Question

  • Hi,


    I tried to create a update with no complexity and for some reason I get the error:

    Operation must use an updatable query

    I checked my query in such a way I update a field on the side with only one relationship and unfortunatelly i still get the error

    Here is the query

    UPDATE A
    INNER JOIN B

    ON A.crmId = B.crmId
    SET A.Frais_depl_SumEUR = 10;

    There is only one line in the table A which ma

    V is a view

    Can you please advise ?

    Thanks

    Regards,

    Pierre-yves Meyer


    Thursday, May 24, 2018 10:12 AM

All replies

  • Change your relationship to be a left join.

    Just takes a click to give thanks for a helpful post or answer.
    Please vote “Helpful” or Mark as “Answer” as appropriate.
    Chris Ward
    Microsoft Community Contributor 2012

    Thursday, May 24, 2018 1:23 PM
  • Here is the query

    UPDATE A
    INNER JOIN B

    ON A.crmId = B.crmId
    SET A.Frais_depl_SumEUR = 10;

    There is only one line in the table A which ma

    V is a view

    What is "V"?  I don't see it mentioned in your query SQL.  Did you mean to type "B"?

    Is B a linked SQL view?  If you open B directly, as a datasheet, is it updatable?


    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html

    Thursday, May 24, 2018 3:44 PM
  • Hi pym,

    Could you share us a simple database which could reproduce your issue?

    I made a test with below query, it works correctly.

    Update tblName
    inner join tblUser
    on tblname.id = tblUser.id
    set tblName.FIRSTNAME = "test"

    Best Regards,

    Tao Zhou


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, May 25, 2018 6:52 AM