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 operation must use an updateable query access 2013 and policies of this site About Us Learn more about Stack Overflow
Operation Must Use An Updateable Query Excel Vba
the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation operation must use an updateable query access 2003 Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it
Operation Must Use An Updateable Query C#
only takes a minute: Sign up Operation must use an updatable query. (Error 3073) Microsoft Access up vote 16 down vote favorite 4 On some Microsoft Access queries, I get the following message: Operation must use an updatable query. (Error 3073). I work around it by using temporary tables, but I'm wondering if there's a better way. All the tables involved operation must use an updateable query access 2010 have a primary key. Here's the code: UPDATE CLOG SET CLOG.NEXTDUE = ( SELECT H1.paidthru FROM CTRHIST as H1 WHERE H1.ACCT = clog.ACCT AND H1.SEQNO = ( SELECT MAX(SEQNO) FROM CTRHIST WHERE CTRHIST.ACCT = Clog.ACCT AND CTRHIST.AMTPAID > 0 AND CTRHIST.DATEPAID < CLOG.UPDATED_ON ) ) WHERE CLOG.NEXTDUE IS NULL; ms-access share|improve this question edited Oct 4 '08 at 21:46 Sklivvz♦ 20.4k2381152 asked Oct 4 '08 at 16:08 Knox 1,99872655 add a comment| 20 Answers 20 active oldest votes up vote 20 down vote accepted Since Jet 4, all queries that have a join to a SQL statement that summarizes data will be non-updatable. You aren't using a JOIN, but the WHERE clause is exactly equivalent to a join, and thus, the Jet query optimizer treats it the same way it treats a join. I'm afraid you're out of luck without a temp table, though maybe somebody with greater Jet SQL knowledge than I can come up with a workaround. BTW, it might have been updatable in Jet 3.5 (Access 97), as a whole lot of queries were updatable then
Operation Must Use An Updateable Query error 53 Comments 30 April 2008 22:48 4.68 (74 votes) ASP.NET 2.0 MS Access ADO.NET ASP.NET 3.5 The unbelievably cryptic Operation Must Use An Updateable Query
Operation Must Use An Updateable Query Access 2007
error is the bane of developers who are just starting out with Access
Operation Must Use An Updateable Query Access Insert
and ASP.NET. You've done your code, plopped your database file in the App_Data folder (or at least, you should have done), operation must use an updateable query excel oledb c# and try to run a page that INSERTs or UPDATEs records, and it all stops dead. This brief article explains the cause of the error, and the steps required to stop it recurring. http://stackoverflow.com/questions/170578/operation-must-use-an-updatable-query-error-3073-microsoft-access When a Jet 4.0 database (the actual type of database represented by your "Access" mdb file) is deployed in a multi-user environment, an .ldb file is created whenever the database is opened. The .ldb file contains details which include who has opened the file, and primarily serves to prevent opened records being written to by another user. In the context of an ASP.NET application, who the "user" http://www.mikesdotnetting.com/article/74/solving-the-operation-must-use-an-updateable-query-error is will depend on the platform: for XP Pro machines, the user is the ASPNET account. On Windows Server 2003, 2008 and Vista, it is the NETWORK SERVICE account. However, if you have ASP.NET Impersonation enabled, the default user account will be IUSR_machinename, or whichever account you have applied. With IIS 7.5, Application Pool Identities were introduced, which will result in your application running under an account named "IIS APPPOOL/name_of_application_pool", If you are unsure which account your ASP.NET application is running under, Environment.UserName will return it. To be able to create, write to and delete the required .ldb file, the relevant user needs MODIFY permissions on the folder that the .mdb file is in. To set this permission, right click on the App_Data folder (or whichever other folder you have put the mdb file in) and select Properties. Look for the Security tab. If you can't see it, you need to go to My Computer, then click Tools and choose Folder Options.... then click the View tab. Scroll to the bottom and uncheck "Use simple file sharing (recommended)". Back to the Security tab, you need to add the relevant account to the Group or User Names box. Click Add.... th
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 http://www.fmsinc.com/Microsoftaccess/query/non-updateable/index.html Basic 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 http://www.xtremevbtalk.com/word-powerpoint-outlook-and-other-office-products/323446-access-error-runtime-error-3073-operation-updateable-query.html ZipCode Database Catalog and Fliers 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 operation must 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 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 operation must use 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 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.
VBA / Office Integration > Word, PowerPoint, Outlook, and Other Office Products > Access error: Runtime error 3073: Operation Must use an Updateable query Thread Tools Display Modes #1 02-23-2012, 07:44 AM Cobolisdead Centurion Join Date: Oct 2006 Posts: 106 Access error: Runtime error 3073: Operation Must use an Updateable query So I am running into an issue with Access 2000 format database using Access 2007. Code: DoCmd.RunSQL "UPDATE tblContEducationExport SET ID_Person = ( SELECT tblPerson.ID_Person FROM tblPerson WHERE tblPerson.CertNum = tblContEducationExport.CertNum) WHERE EXISTS ( SELECT tblPerson.ID_Person FROM tblPerson WHERE tblPerson.CertNum = tblContEducationExport.CertNum);" It keeps giving me this error message. Both the front end and back end files are in trusted locations, so I know its not an issue with that. I opened the table and updated the field manually, and everything worked okay, so its not anything with the tables. I even tried running it in a regular query, but it gives me the same results. Any thoughts? Cobolisdead View Public Profile Find all posts by Cobolisdead #2 02-23-2012, 08:49 AM Cobolisdead Centurion Join Date: Oct 2006 Posts: 106 Code: DoCmd.RunSQL "UPDATE tblPerson INNER JOIN tblContEducationExport ON tblPerson.CertNum=tblContEducationExport.CertNum SET tblContEducationExport.ID_Person = [tblPerson].[ID_Person] WHERE (([tblContEducationExport].[CertNum]=[tblPerson].[CertNum]));" Well, I got it to work using this instead. Cobolisdead View Public Profile Find all posts by Cobolisdead « Previous Thread | Next Thread » Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) Thread Tools Show Printable Version Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home News & Notifications Announcements .Net News & Articles Visual Basic .NET (2002-2015), including Express editions) .NET Knowledge Base Tutors' Corner Code Library ASP.Net .NET Communications .NET Game Programming Managed DirectX .NET Office Automation .NET File I/O and Registr