I made a data grid (An Extensive Examination of the DataGrid Web Control By Scott Mitchell). <BR><BR>For last four days I am stuck with utterly frustrating problem. <BR><BR><BR>I was Scott&#039;s post http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=107 and tried to work in it but it didn’t. <BR><BR> <BR>&#062;&#062; I have given FULL PERMISSIONS to website. <BR>&#062;&#062; Gave full permission to Internet Guest account (IUSR_MACHINE). <BR>&#062;&#062; Unchecked "Read Only" setting may be checked in the Options page for this DSN in the ODBC Manager. <BR>&#062;&#062; MDB file is not “read only”. <BR> <BR><BR>Could anyone advice me?<BR><BR>I am this is the code I am using:<BR><BR>==================================== ============================================<BR><B R> Sub dgProducts_Edit(sender As Object, e As DataGridCommandEventArgs)<BR><BR> dgProducts.EditItemIndex = e.Item.ItemIndex<BR><BR> BindData()<BR><BR> End Sub<BR><BR> <BR><BR> Sub dgProducts_Update(sender As Object, e As DataGridCommandEventArgs)<BR><BR> &#039;Read in the values of the updated row<BR><BR> Dim iProductID as Integer = CType(e.Item.Cells(1).Controls(0), TextBox).Text<BR><BR> Dim dblPrice as Double = CType(e.Item.Cells(2).Controls(0), TextBox).Text<BR><BR> Dim strName as String = CType(e.Item.Cells(3).Controls(0), TextBox).Text<BR><BR> Dim strDesc as String = CType(e.Item.Cells(4).Controls(0), TextBox).Text<BR><BR> <BR><BR> &#039;Construct the SQL statement using Parameters<BR><BR> Dim strSQL as String = _<BR><BR> "UPDATE [Products] SET [ProductName] = @ProdName, " & _<BR><BR> "[UnitPrice] = @UnitPrice, [Description] = @ProdDesc " & _<BR><BR> "WHERE [ProductID] = @ProductID"<BR><BR> <BR><BR> Const strConnString as String = _<BR><BR> "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\Sw-aranea
esidenceResidence est est.mdb"<BR><BR> Dim objConn as New OleDbConnection(strConnString)<BR><BR> objConn.Open()<BR><BR> <BR><BR> Dim myCommand as OleDbCommand = new OleDbCommand(strSQL, objConn)<BR><BR> myCommand.CommandType = CommandType.Text<BR><BR> <BR><BR> &#039; Add Parameters to the SQL query<BR><BR> Dim parameterProdName as OleDbParameter = _<BR><BR> new OleDbParameter("@ProdName", OleDbType.VarWChar)<BR><BR> parameterProdName.Value = strName<BR><BR> myCommand.Parameters.Add(parameterProdName)<BR><BR > <BR><BR> Dim parameterUnitPrice as OleDbParameter = _<BR><BR> new OleDbParameter("@UnitPrice", OleDbType.Currency)<BR><BR> parameterUnitPrice.Value = dblPrice<BR><BR> myCommand.Parameters.Add(parameterUnitPrice)<BR><B R> <BR><BR> Dim parameterProdDesc as OleDbParameter = _<BR><BR> new OleDbParameter("@ProdDesc", OleDbType.VarWChar)<BR><BR> parameterProdDesc.Value = strDesc<BR><BR> myCommand.Parameters.Add(parameterProdDesc)<BR><BR > <BR><BR> Dim parameterProdID as OleDbParameter = _<BR><BR> new OleDbParameter("@ProductID", OleDbType.Integer)<BR><BR> parameterProdID.Value = iProductID<BR><BR> myCommand.Parameters.Add(parameterProdID)<BR><BR> <BR><BR> myCommand.ExecuteNonQuery() &#039;Execute the UPDATE query --- ERROR on this line<BR><BR> <BR><BR> objConn.Close() &#039;Close the connection<BR><BR> <BR><BR> &#039;Finally, set the EditItemIndex to -1 and rebind the DataGrid<BR><BR> dgProducts.EditItemIndex = -1<BR><BR> BindData() <BR><BR> <BR><BR> End Sub<BR><BR> <BR><BR>Error I am getting is: Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.<BR><BR>==================================== ================================================== ====<BR><BR> <BR><BR>Regards, <BR>Aroh Shukla <BR>