Checking success of DB transaction

Hi There



I am trying to insert a record into Microsoft SQL Server database table using ADO objects. The sample code is as follows



Dim AConnection 

  Set AConnection = ADO.CreateADOConnection

  AConnection.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=EASDS;UID=eas_system;PWD=EAS" 

  AConnection.LoginPrompt = False

  AConnection.Open

  AConnection.Execute_("Insert into emp('1','Sankar')



The code works properly. I want to know whether the last statement AConnection.Execute_ is successful or not. Appreciate if you some one can throw a light on this