I created a database in Oracle and then linked it to an Access database using ODBC.
Can someone tell me how i can trap an error from ODBC or Oracle using VBA?

If I use the error object from VBA it gives me just the code 3146 (odbc call failed) followed by the code 7786 (?). The first code is not always the same, sometimes i get the code 3155 (insert on a listed table failed) but always the second code is 7786. But i need the real error code (from Oracle or ODBC) before i can react to that error.