Ms Access 2007 Error Operation Must Use An Updateable Query
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
Operation Must Be An Updateable Query Access 2010
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
Access 2013 Operation Must Use An Updateable Query
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” error in MS Access up vote 9 down vote favorite 2 I operation must use an updateable query access 2003 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 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 = access operation must use an updateable query linked table [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.1k1069107 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, but I solved this by altering my query slightly. Rather than joining a select query to a table and processing it, I changed the select query to create a temporary table. I then used that temporary table to the real table and it all worked perfectly. share|improve this answer answered Nov 5 '13 at 14:08 Andrew Martin 2,84822367 3 Ah, so [Views] was a saved query, was it? Did it by chance do any aggregations (GROUP BY) or anything else that would have made its result s
360 games PC games
Operation Must Be An Updateable Query Access 2013
Windows games Windows phone games Entertainment All Entertainment operation must use an updateable query asp net Movies & TV Music Business & Education Business Students & educators
Operation Must Use An Updateable Query Access 2010 Windows 7
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://stackoverflow.com/questions/19789709/operation-must-use-an-updateable-query-error-in-ms-access 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 https://support.microsoft.com/en-us/kb/316475 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
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 Rate Thread Display Modes 07-14-2011, 02:14 AM #1 gutmj Newly Registered http://www.access-programmers.co.uk/forums/showthread.php?t=212702 User Join Date: May 2008 Posts: 26 Thanks: 5 Thanked 0 Times in 0 Posts operation must use an updatable query Hi, I am executing a simple update query: UPDATE tblMatrix INNER JOIN qrySelectMaxDate ON tblAll.SoldTo = qrySelectMaxDate.SoldTo SET tblMatrix.LastInvoicedDate = [qrySelectMaxDate]![MaxOfInvoiceDate]; and I am receiving an error "operation must use an updatable query". Googled it but not of the explantation seems to be aplicable to my query. Any thoughts? Thanks gutmj View Public Profile Find operation must More Posts by gutmj 07-14-2011, 02:19 AM #2 elliotgr Newly Registered User Join Date: Dec 2010 Posts: 67 Thanks: 4 Thanked 1 Time in 1 Post Re: operation must use an updatable query This occurs when there is a many to one relationship. The best way to resolve is is to use a query to generate the update data table, then use the update data table to update the original table. elliotgr View an updateable query Public Profile Find More Posts by elliotgr 07-14-2011, 02:27 AM #3 spikepl Eledittingent Beliped Join Date: Nov 2010 Location: San Serriffe Posts: 6,143 Thanks: 77 Thanked 976 Times in 955 Posts Re: operation must use an updatable query which record in tblMatrix is supposed to get updated? spikepl View Public Profile Find More Posts by spikepl 07-14-2011, 02:29 AM #4 gutmj Newly Registered User Join Date: May 2008 Posts: 26 Thanks: 5 Thanked 0 Times in 0 Posts Re: operation must use an updatable query Great, thanks a lot. Followed your advice. gutmj View Public Profile Find More Posts by gutmj 07-14-2011, 02:33 AM #5 elliotgr Newly Registered User Join Date: Dec 2010 Posts: 67 Thanks: 4 Thanked 1 Time in 1 Post Re: operation must use an updatable query Change qrySelectMaxDate to a make-table and run it. Call the new table tbl_SelectMaxDate Then change your original query to UPDATE tblMatrix INNER JOIN tbl_SelectMaxDate ON tblAll.SoldTo = tbl_SelectMaxDate.SoldTo SET tblMatrix.LastInvoicedDate = [tbl_SelectMaxDate]![MaxOfInvoiceDate]; Now it should run. elliotgr View Public Profile Find More Posts by elliotgr 07-14-2011, 02:40 AM #6 gutmj Newly Registered User Join Date: May 2008 Posts: 26 Thanks: 5 Thanked 0 Times in 0 Posts Re: operation must use an updatable query Sorry, i was