Updatable query error

[AmyLynnHill]

I have a DB where I run two queries every week that extracts data from a Datawarehouse and appends records to a table. Then i run an update query that updates a policy status on the same table the appended records are added to.
For some reason this week when i try to run the update queary i get the following message:

Operation must use an updatable query.

Anyone familiar with this error? The table in not read-only and no other users are in the db

 

[modest]

Make sure SQL syntax has not changed

 

[AmyLynnHill]

SQL has not changed

 

[namliam]

Did you make sure the indexes and PKs have not changed and are properly used in the connection you are creating?

If there is no PK or it is not used the recordset will be "not update-able"