• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Connection Objects > The Errors Collection

The Errors Collection

Error handling with ADO is a difficult topic because some error messages are meaningless, confusing, or just plain wrong. Even though ADO internal error handling improves with each new version, it still takes some experience to correctly interpret ADO error messages. In addition, messages such as “Several errors occurred” are frustrating.

ADO provides you with two ways to receive information about an error: You can either use the VBA’s Err object or the Connection object’s Errors collection.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint