Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 04-06-2009
Member
 
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.
Reply With Quote
  #2  
Old 04-06-2009
Member
 
Join Date: May 2008
Posts: 24
Re: Error: Operation must use an updateable query

check this out: http://support.microsoft.com/default...;en-us;q175168
Reply With Quote
  #3  
Old 04-06-2009
Member
 
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?
Reply With Quote
  #4  
Old 04-06-2009
Member
 
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));
Reply With Quote
  #5  
Old 04-06-2009
Member
 
Join Date: May 2008
Posts: 2,293
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;
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Error: Operation must use an updateable query"
Thread Thread Starter Forum Replies Last Post
How to fix ?Error 7 (net::ERR_TIMED_OUT): The operation timed out? error message on Safari? Gopal Shrivastav Technology & Internet 2 01-03-2012 09:26 PM
Internet IP error: "The operation failed as no adapter is in the state permissible for this operation" hindustnidude Networking & Security 3 10-09-2009 06:35 PM
Turn on MySQL query cache to speed up query performance DMA2Superman Software Development 3 07-07-2009 10:26 AM
Error 0x8004230f: The shadow copy provider had an unexpected error while trying to process the specified operation Viensterrr Small Business Server 2 04-08-2008 07:30 AM
Ms Access throws "This recordset is not updateable. " Landon MS Office Support 1 22-11-2006 04:12 PM


All times are GMT +5.5. The time now is 10:43 AM.