Syntax error in UPDATE statement

[Suresh Mahesh]

i can't update ms access database

my code is below

con.ConnectionString = ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=J:\1111\11111\VMS.accdb")

 con.Open()

       
 Dim sql As String = "update login set password='11111', where username='suresh'"

        Dim objCmd As OleDbCommand
        objCmd = New OleDbCommand(sql, con)
        'objCmd.Connection.Open()
        objCmd.ExecuteNonQuery()//hear error occurred
        con.Close()

<edit: e-mail address removed>



please answer me

[Jason Kibble]

Try removing the comma after the pasword value. You are only trying to set a single value, so there is no need for a comma.

[Suresh Mahesh]

thank you .. its working