Ms Access 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 about Stack Overflow the company Business Learn more about hiring ms access operation must use an updateable query developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question
Operation Must Use An Updateable Query Access 2013
x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join
Operation Must Use An Updateable Query Access 2003
them; it only takes a minute: Sign up Operation must use an updatable query. (Error 3073) Microsoft Access up vote 2 down vote favorite I have written this query: UPDATE tbl_stock1 SET tbl_stock1.weight1 = ( select (b.weight1 - c.weight_in_gram) as
Operation Must Be An Updateable Query Access 2013
temp from tbl_stock1 as b, tbl_sales_item as c where b.item_submodel_id = c.item_submodel_id and b.item_submodel_id = tbl_stock1.item_submodel_id and b.status <> 'D' and c.status <> 'D' ), tbl_stock1.qty1 = ( select (b.qty1 - c.qty) as temp1 from tbl_stock1 as b, tbl_sales_item as c where b.item_submodel_id = c.item_submodel_id and b.item_submodel_id = tbl_stock1.item_submodel_id and b.status <> 'D' and c.status <> 'D' ) WHERE tbl_stock1.item_submodel_id = 'ISUBM/1' and tbl_stock1.status <> 'D'; I got this error message: Operation must use an updatable query. (Error 3073) access operation must use an updateable query linked table Microsoft Access But if I run the same query in SQL Server it will be executed. Thanks, dinesh ms-access vba access-vba jet share|improve this question edited Aug 5 '09 at 14:34 BIBD 9,0852060102 asked Aug 5 '09 at 5:30 Dinesh add a comment| 5 Answers 5 active oldest votes up vote 2 down vote I'm quite sure the JET DB Engine treats any query with a subquery as non-updateable. This is most likely the reason for the error and, thus, you'll need to rework the logic and avoid the subqueries. As a test, you might also try to remove the calculation (the subtraction) being performed in each of the two subqueries. This calculation may not be playing nicely with the update as well. share|improve this answer edited Aug 5 '09 at 6:24 answered Aug 5 '09 at 6:04 Ben Griswold 9,724114556 Depends on the subquery. Subqueries in WHERE clauses do not have that effect. Subqueries in the FROM may or may not, depending on various issues. The main issue is whether or not Jet/ACE can resolve the relationship type so that it is unambiguously told which single record to update. One thing to try if you're running the SQL in Access itself is the DISTINCTROW predicate, which can sometimes make nonupdatable queries updatable. –David-W-Fenton Aug 5 '09 at 18:30 "The main issue is whether or not Jet/ACE can resolve the rel
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 about Stack Overflow the company Business Learn more about hiring developers or posting ads with operation must use an updateable query access 2010 windows 7 us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow operation must use an updateable query c# Community Stack 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 updateable query vba INSERT INTO in MS Access 2010 SOMETIMES GETS ERROR: 3073 Operation must use an updateable query up vote 1 down vote favorite I get the ERROR: 3073 Operation must use an updateable query SOMETIMES, while performing an INSERT statment. I have no http://stackoverflow.com/questions/1231350/operation-must-use-an-updatable-query-error-3073-microsoft-access problem on my windows 7 PC, but the person I am writing this for sometimes gets the error. She also has MS Access 2010 on Windows 7. As I said I have never got it on my PC, and she only gets it sometimes. The code will insert a number of rows and then through the error, and other times not through the erro at all. The error occurs if I have the code and data in one .mdb file or seperate files. Here http://stackoverflow.com/questions/5201176/insert-into-in-ms-access-2010-sometimes-gets-error-3073-operation-must-use-an-u a snippet of code: OrderHdrInsertStmnt = " INSERT INTO ORDER_HDR " _ & "(ORDER_ID, SOURCE_CODE, ORDER_DATE, SHIP_FNAME, SHIP_LNAME, SHIP_EMAIL, SHIP_COMP, SHIP_PHONE, SHIP_ADDR, SHIP_CITY, SHIP_STATE, SHIP_ZIP, SHIP_CNTRY, " _ & " BILL_FNAME, BILL_LNAME, BILL_EMAIL, BILL_COMP, BILL_PHONE, BILL_ADDR, BILL_CITY, BILL_STATE, BILL_ZIP, BILL_CNTRY, " _ & " TAX, SHIPPING, TOTAL, MOD_DATE, INSERT_DATE) " _ & " VALUES (" _ & "'" & OrderId & "','" & SourceCode & "','" & Orderdate & "','" & ShipFName & "','" & ShipLName & "','" & ShipEmail & "','" & ShipComp & "','" & ShipPhone & "','" & ShipAddr & "','" & ShipCity & "','" & ShipState & "','" & ShipZip & "','" & ShipCntry _ & "','" & BillFName & "','" & BillLName & "','" & BillEmail & "','" & BillComp & "','" & BillPhone & "','" & BillAddr & "','" & BillCity & "','" & BillState & "','" & BillZip & "','" & BillCntry _ & "','" & OrderTax & "','" & OrderShipping & "','" & OrderTotal & "','" & ImportDate & "','" & ImportDate & "');" then I use dbsCurrent.Execute OrderHdrInsertStmnt, dbFailOnError Any assistance would be great! ms-access vba share|improve this question edited Mar 5 '11 at 7:16 Tony Toews 7,02511324 asked Mar 5 '11 at 2:15 Gary 612 Are all of those fields VarChar/Strings? –NoAlias Mar 5 '11 at 2:24 I have a mixture. there are String, Double, Date, and Lon variable types. –Gary Mar 5 '11 at 3:06 Are values (that you are trying to inse
resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events https://msdn.microsoft.com/en-us/library/bb223637(v=office.12).aspx Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers Samples Retired content We’re sorry. The content you requested has been removed. You’ll http://www.utteraccess.com/forum/Runtime-Error-3073-t1917945.html be auto redirected in 1 second. MSDN Library MSDN Library MSDN Library MSDN Library Design Tools Development Tools and Languages Mobile and Embedded Development .NET Development operation must Office development Online Services Open Specifications patterns & practices Servers and Enterprise Development Speech Technologies Web Development Windows Desktop App Development TOC Collapse the table of content Expand the table of content This documentation is archived and is not being maintained. This documentation is archived and is not being maintained. Operation must an updateable query use an updatable query. (Error 3073) You tried to run, open, or modify a query that is not updatable. Possible causes: You attempted to run a query that tried to update a field that cannot be updated. For example, you may have created the query in such a way that you tried to update a field on the one side of a one-to-many relationship. You tried to use the obsolete OpenQueryDef method on a query that is in a database opened for read-only access. The database is read-only for one of the following reasons: You used the OpenDatabase method or the Visual Basic Data control, and opened the database for read-only access. The database file has been defined as read-only in your network operating system. In a network environment, you do not have write privileges for the database file. Close the database, resolve the read-only condition, and then reopen it for read/write a
Custom Search UtterAccess Forums>Microsoft® Access>Access Queries Runtime Error 3073 Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code 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|-- 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 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: Wisconsin Dells, WII have a database that runs smooth in 2003. Trying it in 2007, and the SqlUPDATE tblproductsold SET Cost = '7.99', SuggestedSell = '8.30', Jobber = '6.39' WHERE PartID = 'ABC00004'"gives an error of 3073 'must be an updateable query. I'm guessing that more of this problem will show up."tblproductsold" is a linked table, not a query.Since I'm not familiar