Ms Access Operation Must Use An Updateable 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 access 2013 operation must use an updateable query Learn more about Stack Overflow the company Business Learn more about hiring developers
Operation Must Be An Updateable Query Access
or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack
Operation Must Use An Updateable Query C#
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 an updateable query” error in
Operation Must Use An Updateable Query Access 2003
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. 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 access operation must use an updateable query linked table [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 40.1k1069107 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 Marti
360 games PC games operation must be an updateable query access 2013 Windows games Windows phone games Entertainment All Entertainment operation must use an updateable query asp net Movies & TV Music Business & Education Business Students & educators operation must use an updateable query access 2010 windows 7 Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://stackoverflow.com/questions/19789709/operation-must-use-an-updateable-query-error-in-ms-access 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 Lumia All https://support.microsoft.com/en-us/kb/175168 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
Visual SourceBook Total Access Speller Total Access Startup Total Access Statistics Multi-Product Suites >> Overview of Suites Total Access Ultimate Suite Total Access Developer Suite Total Visual Developer Suite Visual Basic 6 >> Total http://www.fmsinc.com/Microsoftaccess/query/non-updateable/index.html Visual Agent Total Visual CodeTools Total Visual SourceBook Total VB Statistics Multi-Product Suites >> Overview of Suites Total Visual Developer Suite Total Visual Enterprise Suite Sentinel Visualizer Total ZipCode Database Catalog and Fliers https://bytes.com/topic/access/answers/655652-operation-must-use-updateable-query Product Awards Product Reviews Product User Matrix Pre-Sale FAQs Version Compatibility Chart Language Support User Manuals Order News Announcements Current Newsletter Upcoming Events Product Reviews Media Videos Free Resources Overview Product Demos Microsoft operation must Access Developer Help Center Microsoft Access Query Help Center Microsoft Access to SQL Server Upsizing Microsoft Outlook Tips Technical Whitepapers Tips and Techniques Technical Videos Consulting Overview Success Stories Technical Expertise Microsoft Access About About Us Contact Us Why Choose FMS? Awards Quality Pledge Microsoft Access Query Center Query Overview: Basic and Advanced Tips and Techniques Query Blog Retrieving Data Data Normalization Crosstab Query Reports Unique DISTINCT an updateable query vs. DISTINCTROW Comparison Outer Join Not-In Queries Sorting Multiple Null Dates Union vs. Union All SQL Action Queries Append Query versus Make Table Query Update Query Examples and Errors and VBA This Recordset is not updateable Delete Query Examples, Errors and VBA Hide Action Query Warnings in VBA without using SetWarnings Number of Records Affected (VBA/DAO) Statistical Analysis The most popular Microsoft Access Number Cruncher Source Code Library 125,000+ Lines ofRoyalty-Free Module Code SQL Server Upsizing Microsoft Access to SQL Server Upsizing Center Additional Resources Microsoft Access Help Center MS Access Consulting and Programming Microsoft Access Developer Center More Microsoft Access Tips Technical Papers Microsoft Access Products and Add-ins Connect with Us Email Newsletter Developer Team Blog Facebook (Feed) Twitter Support Forum News Features Total Visual Agent 2016 Automate Microsoft Access Database Chores! Total Access Emailer 2016 Send Personalized Emails from Microsoft Access! Updated Microsoft Access to SQL Server Upsizing Center with whitepapers, resources, and SQL Server Express Downloads Get our Latest News Latest Newsletter (Sign up) Blog with us and subscribe to our RSS feed. Follow us on Twitter Dealing with Non-Updateable Microsoft Access Queries and the Use of Temporary Tables by Luke Chung, President
help? Post your question and get tips & solutions from a community of 418,595 IT Pros & Developers. It's quick & easy. "Operation must use an updateable query" P: 5 Mike D OS: Windows XP Professional Microsoft Access 2003 I am trying to update a table in my DB from a tempory table. I need to ensure that if records in the main table match records in the temp table (on the keys) they are replaced/updated by the new data in the temp table. the vba code i am running is below: Expand|Select|Wrap|Line Numbers DimmySQLAsString mySQL="UPDATEtab_Org" mySQL=mySQL&"SETOrg_Name=(SELECTtemp_TabOrg.Org_NameFROMtemp_TabOrgWHEREtemp_TabOrg.ORGKey=tab_Org.ORGKey)" mySQL=mySQL&"WHEREEXISTS(SELECTtemp_TabOrg.ORGKeyFROMtemp_TabOrgWHEREtemp_TabOrg.ORGKey=tab_Org.ORGKey);" DoCmd.SetWarningsFalse DoCmd.RunSQLmySQL DoCmd.SetWarningsTrue This is the update on just one field, when i get it working (fingers crossed) it will update all fields in the main table except the key field. When i run this code i get the error "Runtime error 3073, Operation must use an updateable query." The general concessus in the forum is that this error is due to folder permissions etc. but I have checked these and I have the correct permissions, i have also tried to run the query on my personal computer and i get the same error. When i modified the query to not include the subquery in the SET part, instead just SET Org_Name = "some string" it works fine. Now if it was a permissions error i'm thinking that the query should still not work??? If anyone could help me fix the error or has a better way to achieve what i am trying to do it would be greatley appreciated Thanks Mike D May 31 '07 #1 Post Reply Share this Question 4 Replies Expert Mod 10K+ P: 14,534 MMcCarthy Hi Mike, Try this ... Expand|Select|Wrap|Line Numbers DimmySQLAsString mySQL