-
un-updatable query
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?
Last edited by DBinPhilly; 06-07-2018 at 02:16 PM.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules