Hello,
I am using MS-Access 2007 database as back end. I am having a login table with five feilds. I want to use the change password option. I used update query for this process. But it showing syntax error.
"cmd = new OleDbCommand("update login set Password='" + TextBox9.Text + "', Conformpassword='" + TextBox10.Text + "', where Username='" + TextBox11.Text + "' and Password='" + TextBox8.Text + "'", con);
cmd.ExecuteNonQuery();"
But i checked it. Please can you say the solution for solve this error. I am working in final stage of project. Please i am waiting for your help.
Thank you,
Regards,
Sangeetha