Getting Information about an Error

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

You cannot handle an error until you know something about it. Where you get information about an error depends on what caused it. The two main sources of information about errors are the VBA Err object and the Microsoft® ActiveX® Data Objects (ADO) Error object. The VBA Err object provides information about VBA errors. The ADO Error Object and Errors Collection provide information about data-provider errors that occur when ADO objects are being used to access data. Errors that occur in ADO itself, as opposed to the data provider, are reported to The VBA Err Object.

See Also

Writing Error-Free Code | Design-Time Tools | Run-Time Tools | Script Debugging Tools | Basic Error Handling | Automating Error Handling | Returning Information About an Error | Error Handling in Class Modules | Handling Script Errors | Logging Errors