insert records into Access DB

Question

Hi, Im trying to insert a record into acess but im not sure whats wrong. conn.Open() 'Opens connection to DB sqlCommand = "Select * from MainInfo" AdapterGauge = New OleDbDataAdapter(sqlCommand, conn) ' fill dataset AdapterGauge.Fill(ds, "TableGauge") tempTable = ds.Tables("TableGauge") Dim dtNewRow As DataRow = tempTable.NewRow dtNewRow("Work Order #") = TextBox1.Text tempTable.Rows.Add(dtNewRow) AdapterGauge.Update(tempTable) Thank you