Ac2002 / DAO: non-updatable query

[JotKa]

Hi all

Using Ac2002 with DAO 3.6 and an Oracle backend DB, I encountered an
updating problem:

An SQL UPDATE command with a self join like this:

UPDATE MyTable AS T1 INNER JOIN MyTable AS T2
ON T1.Field1 = T2.Field1
AND T1.Field2 <> T2.Field2
SET T1.Field3 = 'N'
WHERE T2.Field2 = 9999

runs perfectly well when executed as an Access query, but it fails when
executed by
CurrentDb().Execute
with the message
"Operation must use an updatable query." (Err# 3073)

Any suggestions for the reason of the different behaviour?
How can I get it work with the Execute() command?

Thanks for any hint and best regards

JotKa

 

[JotKa]

Problem solved:

JotKa wrote:
Any suggestions for the reason of the different behaviour?

I used Execute() with the dbConsistent flag. This should have worked
according to all what can be taken from the DAO documentation. Unfortunately,
it does not.

I now use it without the flag, and it works; dbUnconsistent (= the default
value), however, is not a desirable option. :-(

Suggestions for improvements:
- dbConsistent should work as described, so the documentation should be
complemented.
- the documentation describing the error message should be complemented,
too, since the answer for my problem could not be found there.

JotKa