Using visual studio 2003 and access data base, Column password datavalue is set as text. when I run command I get "syntax error in update statement"

[Code}
Dim CMD As OleDb.OleDbCommand = New OleDb.OleDbCommand
Try
conSamson.Open()
With CMD
.Connection = conSamson
.CommandType = CommandType.Text
.CommandText = "update tblusers set Password = ' " & txtPassword.Text & " ' WHERE FirstName = ' " & txtFirstName.Text & " ';"
.ExecuteNonQuery()
EndWith
Catch ex As Exception
MessageBox.Show(ex.Message, ex.GetType.ToString)
EndTry
[/code]

__________________
yvk

Try using the following query:

__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.

And the reason for the change is that PASSWORD is a reserved keyword in JET SQL. By putting it between [...] you are telling JET "use this as a field name, not as a keyword."