Microsoft Access Runtime Error 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 About Us Learn more
Ms Access Operation Must Use An Updateable Query
about Stack Overflow the company Business Learn more about hiring developers or posting operation must use an updateable query access 2013 ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack
Operation Must Use An Updateable Query Access 2003
Overflow is a community of 6.2 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 be an updateable query access 2013 vote 17 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 H1.SEQNO access operation must use an updateable query linked table = ( 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.5k2381152 asked Oct 4 '08 at 16:08 Knox 2,00872655 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.2k1177120 answered Oct 4 '08 at 21:12 David-W-Fenton 19.3k22947 Thanks for the explanation. –Knox Oct 5 '08 at 17:02 1 So we have a pretty trivial upda
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
Operation Must Use An Updateable Query Access 2010 Windows 7
Rating: Display Modes 09-14-2011, 12:45 AM #1 bulbisi Newly Registered User Join operation must use an updateable query c# Date: Jan 2011 Location: Brussels, Belgium Posts: 51 Thanks: 8 Thanked 1 Time in 1 Post Run-time error 3073 Operation must
Operation Must Use An Updateable Query Vba
use an updateable 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 http://stackoverflow.com/questions/170578/operation-must-use-an-updatable-query-error-3073-microsoft-access Append Query to Table 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 http://www.access-programmers.co.uk/forums/showthread.php?t=215498 of course I got an 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
Custom Search UtterAccess Forums>Microsoft® Access>Access Queries Runtime Error 3073 http://www.utteraccess.com/forum/Runtime-Error-3073-t1917945.html Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code https://bytes.com/topic/access/answers/442636-run-time-error-3073-a 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|-- operation must 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 an updateable query 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-October 07From: Wiscons
question and get tips & solutions from a community of 418,589 IT Pros & Developers. It's quick & easy. run-time error 3073 P: n/a jj hi I have got the following query which I try to run: UPDATE Qry_temp INNER JOIN Tbl_TEMP ON Qry_temp.Maaned = Tbl_TEMP.Maaned SET " _ & "Tbl_TEMP.Reklamationer = [Qry_temp]![Antal] Tbl_temp is a table and qry_temp a query. when I run the query the run-time error 3073 shows - "You need an updateable query" Any surgestion how to solve this Thanks JJ Jan 8 '06 #1 Post Reply Share this Question 4 Replies P: n/a Terry Kreft Is Qry_temp updateable? Open Qry_temp in datasheet view and see if you can update values if you can't then that's your problem. -- Terry Kreft "jj"