I am trying to update a database using VB.net I have been able to read the file just not update any information in it. After searching the net it seems like there are many different ways to read / write to access. I was hoping that someone knew of a way to write to access without using command builder. The command builder has been a giant hassle and I want to avoid it whenever possible.

This is the code that I am using to read information from Access:
Dim con As New OleDb.OleDbConnection
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
Dim sql As String

Dim intCounter As Integer = 0
Dim con As New OleDb.OleDbConnection
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
Dim sql As String
con.ConnectionString = "PROVIDER=Microsoft.jet.oledb.4.0;Data Source = F:\Visual Basic Files\Magic\CardList.mdb"
sql = "SELECT * FROM CardName"
con.Open()
da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "CardName")
TextBox1.Text = ds.Tables("CardName").Rows(1).Item(1)
con.Close()