if I execute this within vb

ls_SqlString = "Update tblName & _
"Set Active = 'N' " & _
"Where FirstName = 'test'"

with ADO's .Execute

How can one check if the update statement was actually succesful or not...?

beside using the on error goto

thanks