Error: "Operation must use an updateable query." HELP!

P

Paul

I've read everything on this topic here and elsewhere besides. This Error
message is applied too loosely by Microsoft, IMO. Anyway, here's my query:

UPDATE uvw_NeedToReport
SET uvw_NeedToReport.MyFlag = 1
WHERE uvw_NeedToReport.MyFlag = 0;

Way too simple, right? The weirdness is that it succeeds in one ACCESS
module, and in another ACCESS module in the same folder, owned by the same
User, with the the same query, using the same User ID, the same SQL server,
the same ODBC connection, the same database, the same table, gets this
message:
"Operation must use an updateable query."

WHY?? It works in the old version!!

The only difference I found is that the update-successful ACCESS module was
completed in 2005 and the update-failing ACCESS module was completed in 2006.
(I just joined this department and so far have no history of System
upgrades, etc.)

WHY is this same, simple query working in one ACCESS module and not the
other? I analyzed it down to the WSID, and tried changing that. No luck.
I'm fairly proficient with ACCESS, but this has me stumped. Thanks in
advance for any insight into this.
 
Top