ACC: How to Trap Specific ODBC Error Messages (95/97) (183278)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q183278 Advanced: Requires expert coding, interoperability, and multiuser skills.
SUMMARY
You can use the Errors collection to trap specific ODBC errors. However,
you must loop through all of the elements in the collection to access the
ODBC error information. The first element contains only a number and
description for a generic "ODBC Call--failed" error. More specific
information returned by the ODBC data source is available in subsequent
members of the collection.
This article assumes that you are familiar with Visual Basic for
Applications and with creating Microsoft Access applications using the
programming tools provided with Microsoft Access. For more information
about Visual Basic for Applications, please refer to your version of the
"Building Applications with Microsoft Access" manual.
REFERENCES
For more information about trapping ODBC errors in Microsoft Access 2.0,
please see the following article in the Microsoft Knowledge Base:
129165
ACC2: Trapping Specific ODBC Error Messages
For more information about the Errors collection, search the Help Index for
"Errors Collection" and display the topic "Errors Collection (DAO)."
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbhowto kbProgramming KB183278 |
---|
|