see this code

 Private Sub cmdUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdUpdate.Click
        Dim intPosition As Int16
        myCommand = New OleDbCommand
        intPosition = myCurrencyManager.Position
        myCommand.CommandText = "UPDATE login SET Password=@Password WHERE UserId=@UserId"
        myCommand.Parameters.Add("@UserId", BindingContext(myDataView).Current("UserId"))
        myCommand.Parameters.Add("@Password", txtPassword.Text)
        myCommand.CommandType = CommandType.Text
        myCommand.Connection = myConnection

        myConnection.Open()
        Try
            myCommand.ExecuteNonQuery()
        Catch ex As Exception
            MessageBox.Show(ex.ToString)
        End Try
        FillDataSetAndView()
        BindFields()

        myCurrencyManager.Position = intPosition
        ShowPosition()

        StatusBar1.Text = "Record Updated"
        myConnection.Close()
    End Sub

The error is "Syntax error in UPDATE Query" Its is catch by try...catch statement
which is correct form of Query?

In my opinion, it would have been good if this had been continued in the thread where it was begun; that would have made it so that your statements had a context. Saying in this thread that you fixed something means nothing to those who don't know what you fixed...
For those coming to this new, the original is in http://p2p.wrox.com/topic.asp?TOPIC_ID=49965

____________________ _
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ ¯


Perhaps your query is trying to translate the field name as a keyword.

What happens if you use                                or                                ?

Ya Its Working.Thanks.