Getting an error updating a linked table to the SQL server

[malex00]

PLEASE HELP!!!

I'm running this update query:

UPDATE [CSC DEED TABLE] SET [CSC DEED TABLE].Doc_type = ""
WHERE ((([CSC DEED TABLE].Doc_type) Is Null));

It is returning this error message:

Operation must use an updateable query.

The table [CSC DEED TABLE] is a linked table to the SQL server. This update query runs when the ACCESS table is static.
I verified that the SQL server table is exactly the same as the ACCESS linked table.
I have no clue what the error message means.

Thank you for the help.

[rpeare]

When you open your table CSC DEED TABLE and you go to the last record do you have a * and a blank line available?

If you don't, the table has been linked without a primary key and can't be updated, added to or otherwise edited. You'd have to re-link the table with the primary key for any sort of data edits to work.

[malex00]

Thank you for the reply.
I followed your suggestion and it is now working.
Thanks again.