Hi,

I'm getting "Syntax Error in UPDATE statement" when trying to update a record. I'm presuming my UPDATE statement is wrong but am not sure how to go about it as I presume it's a little different from simply adding records. If anyone knows how I should be creating the UPDATE statement I'd be grateful for the help.

Code:
        private void button1_Click(object sender, EventArgs e)
        {
            int sa;
            string compID = null;
            string addone = null;
            string addtwo = null;
            string town = null;
            string county = null;
            string pcode = null;
            string telno = null;
            OleDbConnection myConnection = new OleDbConnection(connectionString);
            try
            {
                    compID = textBox1.Text;
                    addone = textBox3.Text;
                    addtwo = textBox4.Text;
                    town = textBox5.Text;
                    county = textBox6.Text;
                    pcode = textBox7.Text;
                    telno = textBox8.Text;

                    OleDbCommand myCommand = new OleDbCommand("UPDATE Company SET (CompanyAdd = '" + addone + "', CompanyAdd2 = '" + addtwo + "', CompanyTown = '" + town + "', CompanyCounty = '" + county + "', CompanyPCode = '" + pcode + "', CompanyTel = '" + telno + "') WHERE CompanyID = '" + compID + "')", myConnection);
                    OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myCommand);
                    myConnection.Open();
                    sa = myCommand.ExecuteNonQuery();
                    myConnection.Close();
                    MessageBox.Show("Company Updated", "Company details updated", MessageBoxButtons.OK, MessageBoxIcon.Information);
                
            }
            catch (Exception ex)
            {
                MessageBox.Show("Data Load Error: " + ex.Message.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                myConnection.Close();
            }
        }