3073 Odbc Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss operation must use an updateable query access the workings and policies of this site About Us Learn more operation must use an updateable query access 2013 about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow operation must use an updateable query c# Questions Jobs Documentation 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
Operation Must Use An Updateable Query Access 2003
each other. Join them; it 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 access operation must use an updateable query linked table there's a better way. All the tables involved 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 bee
I can read from the DB fine but when I try to do a delete statement it gives me the error : Operation must use and updatable query error # operation must use an updateable query access 2010 windows 7 3073 ... the thing is that it works fine from the query analyzer ..
Operation Must Use An Updateable Query Asp Net
when I cut and paste the code to vb .. it dosen't .. I also can't use the insert statement from VB either
Operation Must Use An Updateable Query Vba
... it gives me a 3158 error 'Insert on linked table ??? failed' .. but the table isn't a linked table .. and also works fine from the query analyzer ... any suggestions ?? http://stackoverflow.com/questions/170578/operation-must-use-an-updatable-query-error-3073-microsoft-access Top Operation must use an updatable query 3073 - ODBC Error by BPMargoli » Thu, 11 May 2000 04:00:00 Tim, My first guess is that the table lacks either a primary key or a unique index. ODBC (not SQL Server) requires that a table possess either a primary key or a unique index for the table to be considered updateable. There is a good reason for this, but it requires a bit of an explanation, http://www.verycomputer.com/156_6a292abc8ee6314f_1.htm and most people really don't care so long as they know how to fix the problem. If you want the reason, continue this thread with a request for it. --------------------------------------------------------------- BP Margolin Please reply only to the newsgroups. When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc) which can be cut and pasted into Query Analyzer is appreciated. Quote:> I am using VB6 to and SQL Server 7.0 .. I can read from the DB fine but > when I try to do a delete statement it gives me the error : Operation must > use and updatable query error # 3073 ... > the thing is that it works fine from the query analyzer .. when I cut and > paste the code to vb .. it dosen't .. > I also can't use the insert statement from VB either ... it gives me a 3158 > error 'Insert on linked table ??? failed' .. but the table isn't a linked > table .. and also works fine from the query analyzer ... > any suggestions ?? Top 1. Operation must use an updatable query. (Error 3073) After updating a table the following message is returned: Error: 3073 Description: Operation must use an updatable query Does anyone have any idea what cause this message a
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 http://www.mikesdotnetting.com/article/74/solving-the-operation-must-use-an-updateable-query-error The unbelievably cryptic 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 http://erwin-knowledgebase.com/index.php?View=pdf&EntryID=3073 your database file in the 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 operation must dead. This brief article explains the cause 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 operation must use 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" 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