MS has released a hot fix for this, but apparently I couldn't apply it to my installation (Office365), so I had to change the update query on my form. There is an original "solution" posted by MS here.
https://support.office.com/en-us/art...3-f21636caedec
In my case the exact change went from this;
Code:
CurrentDb.Execute "UPDATE Logger SET [Logout] = Now() Where ([UserName] = '" & CurUserName & "' AND [ComputerName] = '" & CurComputerName & "' AND IsNull(Logout) );"
to this
Code:
CurrentDb.Execute "UPDATE (SELECT * FROM Logger) SET [Logout] = Now() WHERE ([UserName] = '" & CurUserName & "' AND [ComputerName] = '" & CurComputerName & "' AND IsNull(Logout) );"
I'm lucky in that I only have one or two such queries in my DB, so the task wasn't that difficult.
Does anyone know where I can send the bill to MS for wasting my time