Update Syntax error (Resolved)

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

VB Code:

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

im trying to let the user update the password

try

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

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


thanks all