Operation must use an updateable query.

[Guest]

Although the community has discussed this before, the previous answers don't
work for my case.

I'm getting this error message from ACCESS 2003: "Operation must use an
updateable query."

What's odd is (a) the query is a very simple update query; (b) the query is
a year old and hasn't been changed. (So why did this message suddenly
appear?)

Here's the simple update query:

UPDATE dbo_uvw_NeedToReport
SET dbo_uvw_NeedToReport.PC_Reported = 1
WHERE dbo_uvw_NeedToReport.PC_Reported = 0;

I don't think update queries come any easier than that. Again, it's been
working for a solid year without any errors. Nothing changed. But suddenly
this ACCESS error message appears? What does it mean?

Thanks,
--Paul

 

[Guest]

Assuming that dbo_uvw_NeedToReport is the name of a table and not some fancy
record set in code or another query and nothing has changed like upgrading
from AXP to A03, I'd guess that you may have a corruption problem.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[John Spencer]

This looks as if you might be querying against an MS SQL database.

If that is the case:
Has anything changed on the server?
Can you open the linked table and update the table directly?