I'm utilizing a MS Access database because the after sales of my VB.Internet application. I'm entering customers particulars in to the database utilizing an Place INTO statement:

cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & config("DatabasePath") & ";")
cn.Open()
cmd = New OleDbCommand("INSERT INTO blah blah blah...", cn)
dr = cmd.ExecuteReader

Everything works, however i wanted to see if the information has really been joined in to the database. I've attempted using:

cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & config("DatabasePath") & ";")
cn.Open()
cmd = New OleDbCommand("INSERT INTO blah blah blah...", cn)
dr = cmd.ExecuteReader
If dr.Read() Then
    ' Blah
End If

but clearly the place statement does not return anything which means this does not work. Any suggestions?

If all you've got may be the Place statement you should use the [cde] method which returns the number of rows were affected.

Such as this:

ExecuteNonQuery()

You need to pardon me when the VB is not correct, I did not test drive it, however i hope you get the drift.

Are you able to operate a quick cmd = New OleDbCommand("INSERT INTO blah blah...", cn) rowCount = cmd.ExecuteNonQuery() If rowCount < 1 Then ' Blah utilizing the same key criteria while you employed for the place ?

Make use of the SELECT COUNT(*) FROM blah blah blah method, because the query does not return any result. The technique returns an integer the quantity of rows affected.

ExecuteNonQuery