Ms-Access update problem

See more:

C#

HI Everybody here is my code..If I try with commented part its giving exception Somehting as Incorrect Update Syntax..please help...If i comment that query without password its working fine... try { string path1 = System.Configuration.ConfigurationManager.AppSettings.Get("databasepath"); OleDbConnection con = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + path1); con.Open(); // OleDbCommand cmd = new OleDbCommand("UPDATE codefixermp_tblMembers SET Firstname=@Firstname, Lastname=@Lastname,Address=@Address,City=@City,County=@County,Password=@Password,Comments=@Comments WHERE ID=" + uID.Text + "", con); OleDbCommand cmd = new OleDbCommand("UPDATE codefixermp_tblMembers SET Firstname=@Firstname, Lastname=@Lastname,Address=@Address,City=@City,County=@County,Comments=@Comments WHERE ID=" + uID.Text + "", con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Firstname", txtFirstName.Text); cmd.Parameters.AddWithValue("@Lastname", txtLastName.Text); cmd.Parameters.AddWithValue("@Address", txtAddress.Text); cmd.Parameters.AddWithValue("@City", txtCity.Text); cmd.Parameters.AddWithValue("@County", txtState.Text); //cmd.Parameters.AddWithValue("@Password", txtPassword.Text); cmd.Parameters.AddWithValue("@Comments", txtcomments.Text); cmd.ExecuteNonQuery(); con.Close(); con = null; } catch (Exception ex) { txtFirstName.Text = ex.Message; }