Operation must use an updatable query

[CCIDBMNG]

I have a database that we use for data-entry and payroll for our employees. I have a table which lists all the employees that have worked for us past and present and I have a field in that table called Active. I created a select query to show the SSN each employee who's last pay date to see if it was over 60 days ago. I then created an update query to mark each employee that is on that list to inactive. But when I try to do it that way or even if I just use one update query instead of a select query and update query I get the error "Operation must use an updatable query". Can anyone tell me a way to get around that. The table I am trying to update is a linked table from another database. Does that have anything to do with it???

Thanks in advance.

 

[CCIDBMNG]

Do you mean like a primary key because I have an ID Number field which is my primary key and it is indexed (no duplicates) and it still doesn't work.

 

[CCIDBMNG]

Here is the SQL statement

UPDATE [CCI NEW HIRES] INNER JOIN [Last Paycheck] ON [CCI NEW HIRES].ssn = [Last Paycheck].SSN SET [CCI NEW HIRES].Active = "NO"
WHERE ((([Last Paycheck].[MaxOfPay Date])<DateAdd("d",-60,Date())))
WITH OWNERACCESS OPTION;


But even if I break it down to two queries one that pulls just the SSN for the people over 60 and then a seperate update query just updating based on the SSN it still doen't work.