Wanted to give everyone a heads up on an error I received today in Access 2016. I have a form that calls an Update query that was designed years and years and many versions ago.
This update query has always worked perfectly as does its sister query - one query increments a field in a linked table the other decrements a field in a linked table.
The other day all of a sudden neither query would work - and Access returned the error "....must contain an updatable query"
After searching and searching for the problem and tearing my hair out - I went into the back end (SQLServer) and tried to update the field manually - no problem.
I then went to the Linked Table in the Access application and tried to update the field manually and received the error "This recordset is not updatable" - funny it had always been updatable!
So I relinked the SQLServer table to the front end application and SURPRISE both queries worked perfectly well again.
So I really cannot tell you why doing a Windows 10 update would mess up the link to the table in question but mess it up it did.
Just thought I would post this in case anyone else runs across this problem!