Operation Must Use An Updatable Query. Error 3073
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more operation must be an updateable query access 2010 about Stack Overflow the company Business Learn more about hiring developers or posting ads
Access 2013 Operation Must Use An Updateable Query
with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack operation must use an updateable query c# Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up “Operation must use an updateable query” error in MS Access up vote operation must use an updateable query access 2003 9 down vote favorite 2 I am getting an error message: "Operation must use an updateable query" when I try to run my SQL. From my understanding, this happens when joins are used in update/delete queries in MS Access. However, I'm a little confused because I have another query almost identical in my database which works fine. This is my troublesome query: UPDATE [GS] INNER JOIN [Views] ON ([Views].Hostname
Access Operation Must Use An Updateable Query Linked Table
= [GS].Hostname) AND ([GS].APPID = [Views].APPID) SET [GS].APPID = [Views].APPID, [GS].[Name] = [Views].[Name], [GS].Hostname = [Views].Hostname, [GS].[Date] = [Views].[Date], [GS].[Unit] = [Views].[Unit], [GS].[Owner] = [Views].[Owner]; As I said before, I am confused because I have another query similar to this, which runs perfectly. This is that query: UPDATE [Views] INNER JOIN [GS] ON [Views].APPID = [GS].APPID SET [GS].APPID = [Views].APPID, [GS].[Name] = [Views].[Name], [GS].[Criticial?] = [Views].[Criticial?], [GS].[Unit] = [Views].[Unit], [GS].[Owner] = [Views].[Owner]; What is wrong with my first query? Why does the second query work when the first doesn't? ms-access share|improve this question edited Nov 5 '13 at 18:02 Charles 40.2k1069107 asked Nov 5 '13 at 13:06 Andrew Martin 2,84822367 add a comment| 7 Answers 7 active oldest votes up vote 12 down vote accepted Whether this answer is universally true or not, I don't know, but I solved this by altering my query slightly. Rather than joining a select query to a table and processing it, I changed the select query to create a temporary table. I then used that temporary table to the real table and it all worked perfectly. share|improve this answer answered Nov 5 '13 at 14:08 Andrew Martin 2,84822367 3 Ah, so [Views] was a saved query, was it?
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site operation must be an updateable query access 2013 About Us Learn more about Stack Overflow the company Business Learn more about operation must use an updateable query asp net hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss
Operation Must Use An Updateable Query Access 2010 Windows 7
Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Operation must use http://stackoverflow.com/questions/19789709/operation-must-use-an-updateable-query-error-in-ms-access an updatable query. (Error 3073) up vote 0 down vote favorite I'm using the code below on the front end of my MS-Access database to log activity use. On my desktop, it works fine... when I save the front end to another desktop, I get the following error. "Operation must use an updatable query." (Error 3073) Microsoft Access Can anyone point out my error or http://stackoverflow.com/questions/37552393/operation-must-use-an-updatable-query-error-3073 how to fix?? (I believe I'm using Access 2010 and they are on 2013 - if that matters) Public Sub ActivityLog(Activity As String) CurrentDb.Execute ("INSERT INTO tblActivityLog (UserName, Activity) VALUES('" & TempVars("UserName").Value & "', '" & Activity & "');") End Sub database ms-access access-vba runtime-error share|improve this question asked May 31 at 17:45 Avichai Taylor 43 1 Please see This link, and this question –marlan May 31 at 19:04 Just a hunch, but are you setting CurrentDb somewhere? Have you tried using a stored append query and docmd.openquery? –Christopher D. May 31 at 20:45 What is the back end? do you have to modify the linked tables at the other desktop? –marlan Jun 1 at 7:15 add a comment| active oldest votes Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook. Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy pol
be down. Please try the request again. Your cache administrator is webmaster. Generated Sun, 23 Oct 2016 15:12:40 GMT by s_wx1196 (squid/3.5.20)
query and I got following message when I run it "operation must use an updatable query" The update query has one table and one query and I update the table. Can you please advise where I have look for the message? Your help is great appreciated, iccsi, Feb 17, 2011 #1 Advertisements John W. Vinson Guest On Thu, 17 Feb 2011 12:36:35 -0800 (PST), iccsi <> wrote: >I have an update query and I got following message when I run it > >"operation must use an updatable query" > >The update query has one table and one query and I update the table. >Can you please advise where I have look for the message? > >Your help is great appreciated, Please open the query in SQL view and post the SQL text here. There are quite a few reasons why a query might not be updateable; one common one is that any query which has a GROUP BY, or any query built on a GROUP BY query, is not updateable. -- John W. Vinson [MVP] Microsoft's replacements for these newsgroups: http://social.msdn.microsoft.com/Forums/en-US/accessdev/ http://social.answers.microsoft.com/Forums/en-US/addbuz/ and see also http://www.utteraccess.com John W. Vinson, Feb 17, 2011 #2 Advertisements Access Developer Guest The most common problem users in my user group have found is that they did not include the key field from the table they wanted to update. If you join the table and query on a key field, but the field you retrieve and display is from the query, you may not be able to update the table (even though the values are identical). But, as John says, there are quite a number of reasons. I found Help to be good on explaining why queries may be unupdateable (in some, but not all, versions of Access -- Help is one of the great variables between versions). Larry Linson Microsoft Office Access MVP "John W. Vinson"