Sudden "Operation must use an updateable query" error in 5 year old query

[jlgray0127]

Very unsure of what is happening here?



I have an update query which updates two fields to a calculated value if one value is null

UPDATE Qry_TBL_PRODUCTION_SCHEDULE
SET
Qry_TBL_PRODUCTION_SCHEDULE.MBP_Week = [MBP_DATE] - (DatePart("w", [MBP_DATE], 2, 1) -1),
Qry_TBL_PRODUCTION_SCHEDULE.R_MBP_DATE = [R_MBP_DATE] - (DatePart("w", [R_MBP_DATE], 2, 1) -1)
WHERE
(((Qry_TBL_PRODUCTION_SCHEDULE.MBP_Week) IS NULL));


This query is 5 years old and began getting this error yesterday.

I pulled an older copy of the database and the query runs fine there. The tables are all stored on a backend and the queries are in a local front end database. I've compacted and repaired. I've imported the query that works in the older front end and am still receiving the error. Any thoughts on what to do here?

[ranman256]

you cannot use a query with SUM TOTALS on, AND do an update.
are any of those sub queries listed using SUM? (sum,count,max, etc)

[Welshgasman]

Check for any office update.
Roll back until you can find the issue.