I am trying to update a db from an asp.net page and it keeps giving a 'System.Data.OleDb.OleDbException: Operation must use an updateable query.' error. works fine with a simple SELECT query. The UPDATE query works fine in the db itself.
string strConnection1;
strConnection1 = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection1 += @"Data Source=C:\Inetpub\wwwroot\Estimator2\Estimator.mdb";
string s =
"UPDATE Sales SET Sales_Person =/"Jon Doe/", Sales_Phone = /"555/" WHERE Sales_Number = 1;";
objConnection = new OleDbConnection(strConnection1);
OleDbCommand myCommand = new OleDbCommand(s, objConnection);
myCommand.Connection.Open();
Label1.Text = myCommand.ExecuteNonQuery().ToString();
objConnection.Close();
Thanks for any help!