[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


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

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?
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

LVL 49

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 49

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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

834 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