I'm having trouble with a SQL update statement, getting a syntax error. When I go thru other code in my application, I see similar statements that get no error. WS-ID is defined as SHORT TEXT in the sysUsers table.
sHostName is DESK_FOUR
DoCmd.RunSQL ("UPDATE sysUsers SET WS-ID = '" & sHostName & "'")
what am I doing wrong?