Does anyone know how to update an Acess DB with da

[TomCrazy]

I've spent about a week combing the internet for examples. Every one of them uses SQL SERVER !! I don't have SQL Server, I have Access 2000. I can'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 = '" & txtName & "', "<BR> strUpdateStmt = strUpdateStmt & "Surname = '" & txtSurName & "' "<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, 'Execute' is not a member of 'System.Data.OleDb.OleDbCommand'. What does this mean?