Operation must use an updateable query

[Guest]

This one has me stumped because it should be so simple. The query I use is
this:

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

Too simple, right? Also, in two ACCESS modules, this same Query works in
one, and fails to work in the other, giving the error, "Operation must use an
updateable query".

The User is the same. The ODBC driver is the same. The linked database is
the same. The table updated is the same.

Everything appears to be the same. Yet one ACCESS module updates the DB,
and the other ACCESS module gets this error.

The one difference is that one ACCESS module was completed in late 2005,
while the other ACCESS module was completed in early 2006. (I wasn't here at
that time, and nobody here knows if there was a System upgrade, Service Pack
upgrade, or the like).

Any clues out there?

 

[Guest]

Probably because one of your data files is read only.

However, if uvw is a view, will not be updateable if
primary key is missing, which might have happened
while compacting after database corruption.

(david)