I&#039;ve spent about a week combing the internet for examples. Every one of them uses SQL SERVER !! I don&#039;t have SQL Server, I have Access 2000. I can&#039;t run stored procedures either, my host does not support stored procedures for Access.<BR><BR>How do I code the following to work?<BR><BR> Public Sub DataGrid_Update(Source As Object, E As DataGridCommandEventArgs)<BR> Dim myConnection As OleDbConnection<BR> Dim myCommand As OleDbCommand<BR> Dim txtName as String = CType(E.Item.Cells(2).Controls(0), TextBox).Text<BR> Dim txtSurName as String = CType(E.Item.Cells(3).Controls(0), TextBox).Text<BR> Dim strUpdateStmt As String<BR><BR> strUpdateStmt = "UPDATE Table_Members SET Name = &#039;" & txtName & "&#039;, "<BR> strUpdateStmt = strUpdateStmt & "Surname = &#039;" & txtSurName & "&#039; "<BR> strUpdateStmt = strUpdateStmt & "WHERE ID = " & E.Item.Cells(1).Text<BR><BR> myConnection = New OleDbConnection( _<BR> "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _ <BR> "\premfs2sitespremium7usernamedatabasemyDB.mdb ;" & _ <BR> "Persist Security Info=False;")<BR> myCommand = New OleDbCommand(strUpdateStmt, myConnection)<BR> myConnection.Open()<BR> myCommand.Execute()<BR><BR> memberInfo.EditItemIndex = -1<BR> BindData()<BR> End Sub<BR><BR>By the way, I get a compiler message when running this page that says, &#039;Execute&#039; is not a member of &#039;System.Data.OleDb.OleDbCommand&#039;. What does this mean?