ASP/Access Question

[curtiss]

I am working with ASP VB and Access for the first time, and I have a question about functionality.

Is there any way with ASP VB to check to make sure my query was performed successfully?

In PHP/MySQL, the statement I'm looking for would look something like:

PHP Code:

if(!mysql_query($sql, $link)) {
die("There was an error".mysql_error());
}
else {
echo "Everything went swimmingly";
} 


However, I'm not sure if that is even possible in ASP VB/Access, and if it is, I really don't have the first clue how I would write it. The code I'm currently using is:

	set rsImpact = adoCon.Execute(strSQL)

I just don't see how I would be able to put that into an "if...else" statement. Any help would be appreciated.

[Deadeye]

I've never written VB but inside C# there is a try catch (optional finally) method that will check for any exceptions. I'd look up this or its equivalent for VB.

Sorry I'm not a huge help here, but this is the best i can do.

The try catch method looks like

try
{
   code;
}
catch (Exception e)
{
   MessageBox.Show("There was an error\m" + e.toString());
}
finally
{
   connection.Close();
}

Wesley