with DOA
sorry, DAO, you can do

db.Execute strSQL, dbFailOnError

to return errors from the database engine and trap in the vb code.

how do I do the same with ADO?

cnn.Execute strSQL ??????