Microsoft fixed a known issue occurring for Update queries in Click-2-Run and Windows Installer (MSI) editions of Access 2016, triggering errors when accessing databases and breaking functionality ...

Ok I want to run a SQL query while using the event procedure VB in MS Access.What I'm doing is trying to select a room of a building.So the form goes : Building (and they pick say Smith Hall) then ...

buiild a query that has Month Count (*) fields. then update. if Access says none updatable qruery then do a make table with the sql then update.<BR><BR>Or you could program the solution.