>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
I'm getting an error in an ActiveX file. The error is related to accessing data but the error message only says "Error nnnn, ODBC failed". I need to know *why* it failed... file not found? access rights? what?

Is there a reference table for looking up VB error numbers?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

If the error is being returned through the ActiveX control, odds are pretty good that the developer, not VB, wrote the number/message. You should contact the maker of the ActiveX control.

And in this case, if there's an ODBC layer involved, I wouldn't be shocked if you end up without much info. ODBC errors are not very helpful.

Having said all that, search the MSDN library for "trappable errors" and there's a list.