Results 1 to 4 of 4
  1. #1
    mladen273 is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Dec 2012
    Location
    Zagreb, Croatia
    Posts
    19

    Update table from query

    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?

  2. #2
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536

  3. #3
    mladen273 is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Dec 2012
    Location
    Zagreb, Croatia
    Posts
    19
    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

  4. #4
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Update query won't update table
    By bonesie in forum Access
    Replies: 6
    Last Post: 01-15-2013, 05:22 PM
  2. Replies: 6
    Last Post: 05-10-2012, 08:20 PM
  3. Replies: 1
    Last Post: 02-08-2012, 04:50 PM
  4. Replies: 2
    Last Post: 12-20-2011, 07:33 AM
  5. Replies: 1
    Last Post: 12-16-2011, 08:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums