Access Error Operation Must Be An Updateable Query
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you operation must use an updateable query access 2003 might have Meta Discuss the workings and policies of this site access error 2950 About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or operation must be an updateable query access 2010 posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of operation must be an updateable query access 2007 4.7 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 9 down vote favorite 2 I am getting an error message: "Operation must use an updateable query" when I try to run my SQL.
Access 2013 Operation Must Use An Updateable Query
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 = [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 40k1069107 asked Nov 5 '13 at 13:06 Andrew Martin 2,84321967 add a comment| 7 Answer
One games Xbox 360 games PC
Operation Must Use An Updateable Query C#
games Windows games Windows phone games Entertainment All access operation must use an updateable query linked table Entertainment Movies & TV Music Business & Education Business Students & operation must be an updateable query access 2013 educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security http://stackoverflow.com/questions/19789709/operation-must-use-an-updateable-query-error-in-ms-access Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Band Microsoft https://support.microsoft.com/en-us/kb/175168 Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job https://www.experts-exchange.com/questions/28061195/Access-operation-must-use-an-updateable-query.html Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Access - "operation must use an updateable query" Want to Advertise Here? Solved Access - "operation must use an updateable query" Posted on 2013-03-12 MS Access 5 Verified Solutions 39 Comments 10,666 Views Last Modified: 2013-03-12 Hi! I operation must just created (what I thought was) a simple query. I want it to take data from another query, and update the corresponding fields (based on primary keys) in a table. However, when I try to run it, I get an error - "operation must use an updateable query". Does anyone know why this might be? Here's my SQL, in case you need it. UPDATE SalesRepMonthlyOpenOrdersAggregateQ INNER JOIN an updateable query SalesRepMonthlyT ON (SalesRepMonthlyOpenOrdersAggregateQ.Salesperson = SalesRepMonthlyT.Salesperson) AND (SalesRepMonthlyOpenOrdersAggregateQ.Month = SalesRepMonthlyT.Month) AND (SalesRepMonthlyOpenOrdersAggregateQ.Year = SalesRepMonthlyT.Year) SET SalesRepMonthlyT.OpenOrderPrice = [sumofprice]; Select all Open in new window Thanks!!! 0 Question by:etech0 Facebook Twitter LinkedIn Google LVL 46 Active today Best Solution byDale Fye (Access MVP) You might be able to create a temporary table (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_9753-Creating-and-using-Temporary-Tables-in-Microsoft-Access.html) from your grouping query, Go to Solution 39 Comments LVL 30 Overall: Level 30 MS Access 28 Message Active today Assisted Solution by:hnasr2013-03-12 Convert the query to a select query. If you can add records then the query is updateable, and then update query works. 0 LVL 10 Overall: Level 10 MS Access 4 Message Author Comment by:etech02013-03-12 I can't add records. Why would that be? Should I change the join type, or something? 0 LVL 6 Overall: Level 6 MS Access 4 Message Assisted Solution by:PJBX2013-03-12 From time to time, I run across this issue with Access and update queries. I always get around it by going into SQL View and change your query to: UPDATE SalesRepMonthlyT SET SalesRepMonthlyT.OpenOrderPrice = SalesRepMonthlyOpenOrdersAggregateQ. [sumofprice] FROM SalesRepMonthlyT, SalesRepMonthlyOpenOrdersAggregateQ WHERE SalesRepMonthlyOpenOrdersAggregateQ.Salesperson =