DAO probably has an Errors collection, but IMHO ADO is probably a better route; and I would think you would want to emply DNS-less Connection Strings. Anyway, check out the errors collection here.
http://www.w3schools.com/ado/ado_ref_connection.asp
.02 Stan