Update Syntax error (Resolved)

[señorbadger]

Hi this code keeps bringing up a syntax error but it looks fine any ideas??

Set myrs = MyConn.Execute("UPDATE users SET Password = '" _
          & TxtnewPWD.Text & "' WHERE UserName ='" & username & "'")

im trying to let the user update the password

[kovan]

try

Set myrs = MyConn.Execute("UPDATE users SET [Password] = '" _
& TxtnewPWD.Text & "' WHERE UserName ='" & username & "'")

[señorbadger]

thanks for ya help but as i realised username and password are reserved words and can be field names


thanks all