Error 3073 Access
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 Learn runtime error 3073 more about Stack Overflow the company Business Learn more about hiring developers or posting runtime error 3073 operation must use an updateable query ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack avaya error 3073 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 updatable query. (Error 3073) Microsoft Access up operation must use an updateable query access 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 H1.paidthru FROM CTRHIST as H1 WHERE H1.ACCT = clog.ACCT AND
Operation Must Use An Updateable Query Access 2013
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 that became non-updatable when upgraded to Jet 4. -- share|improve this answer edited Oct 24 '12 at 13:53 Anirudh Ramanathan 32k1177120 answered Oct 4 '08 at 21:12 David-W-Fenton 19.2k22947 Thanks for the explanation. –Knox Oct 5 '08 at 17:02 1 So we have a pretty t
Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rating: Display
Operation Must Use An Updateable Query Access 2003
Modes 09-14-2011, 12:45 AM #1 bulbisi Newly Registered User Join Date: Jan operation must be an updateable query access 2013 2011 Location: Brussels, Belgium Posts: 51 Thanks: 8 Thanked 1 Time in 1 Post Run-time error 3073 Operation must use an updateable access operation must use an updateable query linked table query Hello all, it looks like i have an issue. I wanted to avoid a kind of temporary table as the DB I'm creating is quite heavy and complex already. Before: 1 Append Query to Table http://stackoverflow.com/questions/170578/operation-must-use-an-updatable-query-error-3073-microsoft-access 1 Update Query to fill a new table from the previously created table It worked like a charm but was way to heavy and slow to control (more than 22.000 records every week just for this table) So I wanted to use a Select Query instead the first step After: 1 Select Query 1 Update Query to fill a new table from the previous Select Query Then of course I got an http://www.access-programmers.co.uk/forums/showthread.php?t=215498 error 3073. Note: The update query is running through VBA. Note: I might try a nested Select into the update Query, but i really don't know how to use it. Note: Access 2010 Code for Select Query: Code: SELECT T_CE_TOBE.DebtorNumber, Max(DateDiff("m",[EndOfMonthDate],DateAdd("m",[tblco.Ter],[tblCO.StsLIVDat]))) AS ResidualMonths FROM T_CE_TOBE INNER JOIN tblCO ON T_CE_TOBE.DebtorNumber = tblCO.DebNum GROUP BY T_CE_TOBE.DebtorNumber; Code for Update Query (in VBA): Code: UpdateMonths = "UPDATE T_CE_TOBE LEFT JOIN Q_CE_TOBE_periods ON T_CE_TOBE.DebtorNumber = Q_CE_TOBE_periods.DebtorNumber SET T_CE_TOBE.ResidualMonths = [Q_CE_TOBE_periods].[ResidualMonths]" DoCmd.RunSQL UpdateMonths Any help is really appreciated and thanks a lot in advance bulbisi View Public Profile Find More Posts by bulbisi 09-14-2011, 10:18 AM #2 PNGBill Win XP MS Access 2010 Join Date: Jul 2008 Location: Papua New Guinea & NZ Posts: 2,251 Thanks: 63 Thanked 77 Times in 73 Posts Re: Run-time error 3073 Operation must use an updateable query You can delete the temporary table or all records in that table once it has served it's purpose. Did you test the query first before putting it into your vba code ? The code for your query doesn't look correct. I thought you needed Insert not Update when adding a new record to a table. Update will change the value of a field in an exisitng record. Insert appends
DriverDoc WinSweeper SupersonicPC FileViewPro About Support Contact Errors Troubleshooting › Runtime Errors › Microsoft Corporation › Microsoft Access › Error 3073 How To Fix Microsoft Access Error 3073 Error Number: Error 3073 Error Name:Microsoft Access Error 3073 Error Description: http://www.solvusoft.com/en/errors/runtime-errors/microsoft-corporation/microsoft-access/3073-microsoft-access-error-3073/ Operation must use an updateable query. Developer:Microsoft Corporation Software:Microsoft Access Applies to:Windows XP, Vista, 7, 8 Download NowWinThruster 2015 - Scan your PC for computer errors. Compatible with Windows 10, 8, 7, Vista, https://bytes.com/topic/access/answers/655652-operation-must-use-updateable-query XP and 2000 Symptoms of Error 3073 "Error 3073" appears and crashes the active program window. Your PC frequently crashes with Error 3073 when running the same program. “Microsoft Access Error 3073” is operation must displayed. Windows runs sluggishly and responds slowly to mouse or keyboard input. Your computer periodically “freezes” for a few seconds at a time. These 3073 error messages can appear during program installation, while a Microsoft Corporation-related software program (eg. Microsoft Access) is running, during Windows startup or shutdown, or even during the installation of the Windows operating system. Keeping track of when and where your 3073 an updateable query error occurs is a critical piece of information in troubleshooting the problem. Causes of Error 3073 Corrupt download or incomplete installation of Microsoft Access software. Corruption in Windows registry from a recent Microsoft Access-related software change (install or uninstall). Virus or malware infection that has corrupted Windows system files or Microsoft Access-related program files. Another program maliciously or mistakenly deleted Microsoft Access-related files. Runtime Errors such as “Error 3073” can be caused by a variety of factors, so it is important that you troubleshoot each of the possible causes to prevent it from recurring. Runtime Errors Knowledgebase Article ID: 125736 Article Author: Jay Geater Last Updated: 24-07-2016 Popularity: star rating here Download NowError Fix Learn More Tweet Recommendation: Scan your PC for computer errors. How To Fix Microsoft Access Error 3073 Below is a list of troubleshooting steps to resolve your Error 3073 problems. These troubleshooting steps get progressively more difficult and time consuming, so we strongly recommend attempting them in ascending order to avoid unnecessary time and effort. Please Note: Click the [ ] image to expand the troubleshooting instructions for each step below. You can also click the [ ] image to hide the i
help? Post your question and get tips & solutions from a community of 418,510 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