Results 1 to 3 of 3
  1. #1
    bhushan98 is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2009
    Posts
    3

    Operation must use an updatable query-- error

    Sir,




    XP/ Vb6/access2003


    On the above platform I am trying to run a query in VB6


    UPDATE monrepo AS a INNER JOIN (select rocode,sum(ms) as s_ms, sum(hsd) as s_hsd from tr_data where tr_month in ('4') and fy = '2012-2013' group by rocode) AS b ON a.rocode=b.rocode SET a.cur_***_ms = b.s_ms, a.cur_***_hsd = b.s_hsd




    I am getting an ambiguous error "Operation must use an updatable query"


    Pl. tell me where is the problem and how to get rid off


    Neeraj

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    This link should help: http://allenbrowne.com/ser-61.html

  3. #3
    bhushan98 is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2009
    Posts
    3
    Thanks Dear

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

Similar Threads

  1. Operation must be an updatable query
    By Lorlai in forum Queries
    Replies: 5
    Last Post: 02-02-2012, 02:04 PM
  2. Replies: 0
    Last Post: 11-29-2011, 01:06 PM
  3. Replies: 2
    Last Post: 06-13-2011, 06:04 PM
  4. Replies: 21
    Last Post: 01-31-2010, 08:51 AM
  5. Replies: 2
    Last Post: 11-02-2009, 10:14 PM

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