I am using VB6.0 as the front-end with MS Access 2003 as the back-end for my project.

I have an insert statement to insert an entry in the database. I use
Con.execute sql1,,adExecuteNoRecords

Now, I want to validate my form. I want to display a Success message if the insertion statement is executed successfully; else I want to display an error message to the user. How do I check if con.execute really works??

Please help...

Thanks in advance  

Hi again

As Goran pointed out, you can get the number of records affected by using the below code.

Dim RecordsAffected as long connection.Execute CommandText, RecordsAffected, Options

Then you can do

If RecordsAffected = 0 then     msgbox "Nothing done" else     msgbox RecordsAffected & " Records inserted / Updated" endif

Steve  

Hey thnks once again,steve.It worked.

Thanks to everyone here for your quick replies.I'm glad I found this site...