I am using the follwing code to insert things into a Access 2003 DB:
Is there an easy way to see or to verify that this is completed?Code:Dim strSQL As StringBuilder Dim strconn As String Dim connection As New OleDb.OleDbConnection strconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbplace connection.ConnectionString = strconn connection.Open() Dim command As New OleDb.OleDbCommand command.Connection = connection command.CommandText = "INSERT Into ocuff1(ocuff1,CYCLE_RAT_1_ID,session_id ) Values ('" & rat1ocuff.ToString & "'," & CYCLE_RAT_1_ID & ",'" & cycleid & "')" command.ExecuteNonQuery()
In other words I want to know that it is done before I move on.
Thanks,
Bebandit




Reply With Quote