Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


MS Access 2003: Operation must use an updateable query

Posted on 2010-09-21
Medium Priority
Last Modified: 2013-11-27

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));
Question by:bigtwig
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Author Comment

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

Expert Comment

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

Author Comment

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?
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 48

Accepted Solution

Dale Fye earned 1000 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.
LVL 31

Assisted Solution

hnasr earned 1000 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.

Author Closing Comment

ID: 33843847
Never got it to work, but you gave me good places to look. Thanks.
LVL 48

Expert Comment

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

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

618 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