Originally Posted by psyc0tic1
I don't have an issue on my computer... it is happening to one of my users overseas. I have no idea what version of office they have or what version of windows they are using. Terrible language barrier and always 24 hours delay in getting answers
Well that complicates matters.
My suggestion was to do this
Dim strSQL as String
strSQL = "UPDATE tbl_users SET Version = '" & FEVersion & "' WHERE ID = " & Credentials.UserId
Now you can set a breakpoint on the DoCmd line or insert a Debug.Print between those lines and see what the string actually contains.
At present you are assuming there are valid values for FEVersion and Credentials.UserId. If there were, the syntax should be correct.?
So my 'guess' is one of those has no or invalid content.? if this has been working fine and not been changed, then it can only be the data that is causing it.?