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

Using the Errors Collection

The Errors collection is part of Access's Jet Engine. It stores the most recent set of errors that have occurred. This is important when dealing with DAO and ODBC, when one operation can result in multiple errors. If you are concerned with each error that was generated by one operation, you need to look at the Errors collection. The Errors collection has the same properties as the Err object. If you want to view the errors stored in the Errors collection, you must loop through it, viewing the properties of each Err object. Listing 17.13 shows the code you can use to accomplish this.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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