Access Error 3073 Operation Must Use An Updateable Query
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
Microsoft Access Operation Must Use An Updateable Query
About Us Learn more about Stack Overflow the company Business Learn more about access operation must use an updateable query linked table hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join
Operation Must Use An Updateable Query Access 2013
the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up “Operation must use an operation must use an updateable query access 2007 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. 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 operation must use an updateable query access 2010 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 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|i
be down. Please try the request again. Your cache administrator is webmaster. Generated Fri, 30 Sep 2016 00:59:44 GMT by s_hv987 (squid/3.5.20)
Visual SourceBook Total Access Speller Total Access Startup Total Access Statistics Multi-Product Suites >> Overview of Suites Total Access Ultimate Suite http://www.fmsinc.com/Microsoftaccess/query/non-updateable/index.html Total Access Developer Suite Total Visual Developer Suite Visual Basic http://www.utteraccess.com/forum/Runtime-Error-3073-t1917945.html 6 >> Total 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 Product Awards Product Reviews Product User Matrix operation must 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 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 operation must use 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 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
Custom Search UtterAccess Forums>Microsoft® Access>Access Queries Runtime Error 3073 Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code Archive|-- Access Knowledgebase / FAQ|-- Access TutorialsMicrosoft® Access|-- Local Access User Groups (AUGs)|-- Interface Design|-- Access Q and A|-- Access Tables + Relationships|-- Access Queries|-- Access Forms|-- Access Reports|-- Access Macros|-- Access Modules|-- Access Date + Time|-- Access Errors + Error Handling|-- Access Built-in Functions|-- Access Searching + Data Mining|-- Access Records|-- Access Security|-- Access Automation|-- Access Database Container|-- Tool bars, Menu bars + Ribbon|-- Access Services (Web Databases)|-- Access Data Access Pages (Deprecated)|-- Access Data Projects - ADP|-- Access Runtime, Packaging & DeploymentAnd More...|-- Microsoft SQL Server|-- SQL Server Reporting Services|-- Microsoft SharePoint|-- Microsoft Internet Explorer|-- Visual Basic 6 and Earlier|-- Visual Basic 2003 and Later|-- ASP and VBScript|-- Web Development|-- PHP, Perl, MySQL and Postgres|-- Other Database Engines|-- BI Tools and Applications|-- JAVA and C#|-- GraphicsMicrosoft® Office|-- Microsoft Excel|-- Microsoft Excel FAQs|-- Microsoft Word|-- Microsoft Outlook|-- Microsoft PowerPoint|-- Microsoft FrontPage/Exp. Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- Q & A - UtterAccess.com Forums|-- Q & A - Access Wiki Options trimarkView Member Profile Dec 28 2009, 06:44 PM Post#1Posts: 64Joined: 13