Obtaining detailed ODBC errors

[zorplex]

When I run a pass-through query in Access, if an ODBC error occurs after the full ODBC error message is displayed in a second message box that appears after the initial "ODBC Call failed".

Is it possible to obtain this ODBC error message in VBA. The Err object only gives me "ODBC Call failed" whereas I need to trap and log based on the the type of ODBC error.

Any suggestions gratefully received!