Solved

MS Access 2003: Operation must use an updateable query

Posted on 2010-09-21
7
493 Views
Last Modified: 2013-11-27
Hi,

Looks like a pretty harmless query, but I get 'Operation must use an updateable query' message.

UPDATE tblUpdateDetailWrk INNER JOIN IOT_Data ON (tblUpdateDetailWrk.ITEM=IOT_Data.PART) AND (tblUpdateDetailWrk.STNO=IOT_Data.LOCATION) AND (tblUpdateDetailWrk.LINE=IOT_Data.MFG) SET tblUpdateDetailWrk.IOTTrigger = IOT_Data.WEIGHTED_COVERAGE
WHERE (((IOT_Data.WEIGHTED_COVERAGE) Is Not Null) And ((tblUpdateDetailWrk.Update)=Forms!DataLoadForm!UpdateName));
0
Comment
Question by:bigtwig
7 Comments
 
LVL 2

Author Comment

by:bigtwig
ID: 33726986
The IOT_Data table is an ODBC linked table in Oracle, but this is working in many other places...
0
 
LVL 3

Expert Comment

by:JefKve
ID: 33727062
Looks like you are trying to update two tables at once, which I beleive is not allowed....
0
 
LVL 2

Author Comment

by:bigtwig
ID: 33727140
I'm only trying to update one field: tblUpdateDetailWrk.IOTTrigger and setting it to IOT_Data.WEIGHTED_COVERAGE... what am I doing wrong or what am I doing that makes it appear I'm trying to update two tables?
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 250 total points
ID: 33727306
There are a number of reasons why a query might not be updatable.  Check out Allen's list at: http://www.allenbrowne.com/ser-61.html

The one that is probably most likely is:

The fields in a JOIN are not indexed correctly (there is no PK or unique index on the JOINed fields.
0
 
LVL 30

Assisted Solution

by:hnasr
hnasr earned 250 total points
ID: 33729692
Attach a database with the 2 tables and query. Import the linked table and make sure the issue is still holding.
0
 
LVL 2

Author Closing Comment

by:bigtwig
ID: 33843847
Never got it to work, but you gave me good places to look. Thanks.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 33843898
If you could post the two tables, as hnasr suggested, we might be able to provide a better solution.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now