Operation Must Use An Updateable Query. Error 3073
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 2010
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
Operation Must Use An Updateable Query C#
Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 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 updateable query” error in MS Access up vote 9 down vote favorite 2 I am getting an error message: "Operation must use an updateable query" when I try to run my SQL. From my understanding, this happens when joins are used in update/delete access operation must use an updateable query linked table queries in MS Access. However, I'm a little confused because I have another query almost identical in my database which works fine. This is my troublesome query: UPDATE [GS] INNER JOIN [Views] ON ([Views].Hostname = [GS].Hostname) AND ([GS].APPID = [Views].APPID) SET [GS].APPID = [Views].APPID, [GS].[Name] = [Views].[Name], [GS].Hostname = [Views].Hostname, [GS].[Date] = [Views].[Date], [GS].[Unit] = [Views].[Unit], [GS].[Owner] = [Views].[Owner]; As I said before, I am confused because I have another query similar to this, which runs perfectly. This is that query: UPDATE [Views] INNER JOIN [GS] ON [Views].APPID = [GS].APPID SET [GS].APPID = [Views].APPID, [GS].[Name] = [Views].[Name], [GS].[Criticial?] = [Views].[Criticial?], [GS].[Unit] = [Views].[Unit], [GS].[Owner] = [Views].[Owner]; What is wrong with my first query? Why does the second query work when the first doesn't? ms-access share|improve this question edited Nov 5 '13 at 18:02 Charles 40.2k1069107 asked Nov 5 '13 at 13:06 Andrew Martin 2,84822367 add a comment| 7 Answers 7 active oldest votes up vote 12 down vote accepted Whether this answer is universally true or not, I don't know, b
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
Operation Must Be An Updateable Query Access 2013
Stack Overflow the company Business Learn more about hiring developers or posting ads with operation must use an updateable query asp net us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is
Operation Must Use An Updateable Query Access 2010 Windows 7
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 vote 2 down http://stackoverflow.com/questions/19789709/operation-must-use-an-updateable-query-error-in-ms-access vote favorite I have written this query: UPDATE tbl_stock1 SET tbl_stock1.weight1 = ( select (b.weight1 - c.weight_in_gram) as 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 <> http://stackoverflow.com/questions/1231350/operation-must-use-an-updatable-query-error-3073-microsoft-access '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) 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 s
360 games PC games https://support.microsoft.com/en-us/kb/175168 Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet operation must Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All an updateable query Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft