Handling Server-Generated Errors

When you receive an ODBC error from Microsoft Jet, the error message does not contain the specific error that occurred on the server. This message is stored in the Errors collection. As described in Chapter 2, “Introducing Data Access Objects,” the Errors collection is a zero-based collection of error messages that starts with the first error that occurs. You can walk through the Errors collection to display all messages logged by the system. The VerboseErrorHandler function, shown earlier in this chapter, gives information on all errors in the Errors collection.

Note The information in this section applies to both Microsoft Jet and ODBCDirect Workspace objects.