通过从sql server加入表来更新访问表

I am using access and sql server combined. My main tables are housed in sql server, and my temp tables are created in access. I am trying to update a temp table in access by joining a table from sql server. But i keep getting the error, operation must use an updateable query. Here is my query below. Any help would be greatly appreciated. I am using access and sql server combined. My m