ExecutiveNonQuery() returns 0

[hkl]

I have a question about using ExecutiveNonQuery() in C# (using Access). The following code would return 0, when I specify "@myMax".Value = 1 (see below). However, if I changed @myMax to a constant (ie. not using a variable), everything worked fine and it returned 1 as the result. The problem is that since it doesn't throw an exception, and only returns 0, I have no idea what's wrong with the "Update" SQL statement. Thank you and appreciate any feedbacks!! // Updates the MAX, and NOTE field of a particular record OleDbCommand myUpdate = new OleDbCommand("UPDATE Product SET **Prod_max = @myMax**, Prod_desc = @myNote WHERE Prod_id = @myID", oleDbConnection1); myUpdate.Parameters.Add("@myNotes", OleDbType.LongVarWChar); myUpdate.Parameters.Add("@myID", OleDbType.VarChar); myUpdate.Parameters.Add("@myMax", OleDbType.SmallInt); myUpdate.Parameters["@myNotes"].Value = Notestxtbox.Text.ToString(); myUpdate.Parameters["@myID"].Value = ProdIDtxtbox.Text.ToString(); **myUpdate.Parameters["@myMax"].Value = 1;** try { textBox1.Text = myUpdate.ExecuteNonQuery().ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "Error", MessageBoxButtons.OK,MessageBoxIcon.Exclamation); }