Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 508
  • Last Modified:

MS Access 2003: Operation must use an updateable query

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
bigtwig
Asked:
bigtwig
2 Solutions
 
bigtwigAuthor Commented:
The IOT_Data table is an ODBC linked table in Oracle, but this is working in many other places...
0
 
JefKveCommented:
Looks like you are trying to update two tables at once, which I beleive is not allowed....
0
 
bigtwigAuthor Commented:
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Dale FyeCommented:
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
 
hnasrCommented:
Attach a database with the 2 tables and query. Import the linked table and make sure the issue is still holding.
0
 
bigtwigAuthor Commented:
Never got it to work, but you gave me good places to look. Thanks.
0
 
Dale FyeCommented:
If you could post the two tables, as hnasr suggested, we might be able to provide a better solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now