操作必须使用可更新的查询。 （错误3073）Microsoft Access

On some Microsoft Access queries, I get the following message: Operation must use an updatable query. (Error 3073). I work around it by using temporary tables, but I'm wondering if there's a better way. All the tables involved have a primary key. Here's the code:On some Microsoft Access queries, I get the fol