Results 1 to 5 of 5

Thread: Error: Operation must use an updateable query

  1. #1
    Join Date
    May 2008
    Posts
    30

    Error: Operation must use an updateable query

    Hello,

    I got this error "Operation must use an updateable query"
    I dont understand what does it mean please someone help me out with this.

    Thanks in advance.

  2. #2
    Join Date
    May 2008
    Posts
    24

    Re: Error: Operation must use an updateable query


  3. #3
    Join Date
    May 2008
    Posts
    29

    Re: Error: Operation must use an updateable query

    On which line you got the error?
    Can you put your code please?
    Is it access SQL?

  4. #4
    Join Date
    May 2008
    Posts
    30

    Re: Error: Operation must use an updateable query

    OK here it goes.

    Code:
    UPDATE [Data Extract]
    SET [Data Extract].[Unit a] =
    (SELECT  [Unit c]![Unit b]  FROM [Unit c] WHERE  [Unit c]![Country] ="Not Listed")
    WHERE ((([Data Extract].[Unit a]) Is Null));

  5. #5
    Join Date
    May 2008
    Posts
    2,297

    Re: Error: Operation must use an updateable query

    Using a subquery in an update query is not allowed.
    instead do this.
    Code:
    UPDATE [Data Extract]
    SET [Data Extract].[Unit a] =
    DLookup("Unit b","Unit c", "Country ='Not Listed'")
    WHERE [Data Extract].[Unit a] Is Null;

Similar Threads

  1. Replies: 2
    Last Post: 01-03-2012, 09:26 PM
  2. Replies: 3
    Last Post: 10-09-2009, 06:35 PM
  3. Turn on MySQL query cache to speed up query performance
    By DMA2Superman in forum Software Development
    Replies: 3
    Last Post: 07-07-2009, 10:26 AM
  4. Replies: 2
    Last Post: 04-08-2008, 07:30 AM
  5. Ms Access throws "This recordset is not updateable. "
    By Landon in forum MS Office Support
    Replies: 1
    Last Post: 22-11-2006, 04:12 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,638,950.88194 seconds with 16 queries