Error Number 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
Operation Must Use An Updateable Query Access 2010
About Us Learn more about Stack Overflow the company Business Learn more about operation must use an updateable query access 2013 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 C#
Join 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 2003 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 have a primary key. Here's the code: UPDATE CLOG SET CLOG.NEXTDUE = ( SELECT operation must be an updateable query access 2013 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 2,00372655 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 that became non-updatable when upgraded to Jet 4. -- share|improve this answer edited Oct 24 '12 at 13:53 Anirudh Ramanathan 32.1k1177120 answered Oct 4 '08 at 21:12 David-
be down. Please try the request again. Your cache administrator is webmaster. Generated Fri, 14 Oct 2016 09:25:55 GMT by s_wx1131 (squid/3.5.20)
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 http://www.mikesdotnetting.com/article/74/solving-the-operation-must-use-an-updateable-query-error Operation Must Use An Updateable Query error is the bane of developers who are just starting out with Access and ASP.NET. You've done your code, plopped your database file in the https://www.experts-exchange.com/questions/20703637/Operation-must-use-an-updatable-query-Error-3073.html App_Data folder (or at least, you should have done), and try to run a page that INSERTs or UPDATEs records, and it all stops dead. This brief article explains the cause operation must of the error, and the steps required to stop it recurring. 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 an updateable query records being written to by another user. In the context of an ASP.NET application, who the "user" 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 Vie
for 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 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 > Operation must use an updatable query. (Error 3073) Want to Advertise Here? Solved Operation must use an updatable query. (Error 3073) Posted on 2003-08-08 MS Access 1 Verified Solution 2 Comments 1,818 Views Last Modified: 2012-06-21 I work in an Access 97 Database and there are many tables which are linked with SQL Server. Until 2 days the following code worked fine, but suddenly it begins to give Run-time Error 3073. Both Tables are used in the "qry_frmMonthlyPolicy_assistance_append" query and they need to have no records. They have no primary key and when I try to delete records from them manually from Access I couldn't do it. I could only delete records from them from SQL Server side. I didn't open database in read-only mode (I can delete records from other linked tables) and I have permission to delete them. Could please someone help me? Thanks Code Private Sub Button12_Click() DoCmd.SetWarnings False DoCmd.RunSQL "delete from tmpMonthlyRiskValue" --- Problem is in this line--- DoCmd.RunSQL "delete from rptMonthlyRiskValue" --- Problem is in this line--- DoCmd.OpenQuery "qry_frmMonthlyPolicy_assistance_append" DoCmd.SetWarnings True MonthlyPolicy DoCmd.OpenReport "rptMonthlyPolicy_assistance", acViewPreview Error Message: Operation must use an updatable query. (Error 3073) You tried to run, open, or modify a query that isn't updatable. Possible causes: • You attempted to run a query that tried to update a field that can't be updated. For example, you may have created the q