but an erro occurs specifying that syntax error in update statement.Plz tell me how i could rewrite the code

cmd = New OleDbCommand("update login SET password=@password where username=@username", con)

Password is reserved of Ms-Access.

cmd = New OleDbCommand("update [login] SET [password]=@password where [username]=@username", con)
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.