un-updatable query

[DBinPhilly]

An old customer I haven't talked to in 8 years had a power outage last night and they had a data corruption.

They called me, I fixed the corruption. They are using Windows 8 and MS Access 2010.

A query using two tables is being recalcitrant. Each table individually is updateable, but a query using both is not.

Message: This recordset is not updateable

Any ideas?

[DBinPhilly]

I have corrected the problem. Looking at the backend database, I discovered that one of the tables in the query did not have a primary key (don't ask why?). Previously all queries were working anyway. But I added a primary key to the table and the recalcitrant query worked immediately. Why it worked fine for the last 8 years without a primary key but then suddenly stopped is beyond me.