Can't get real oracle error with Access error 3155

[Stef13]

Hi,

I'm using Access 2003 and i have a oracle linked table with ODBC.
When i try to insert in that table, i get an error 3155 (Insert on a linked table failed) but the oracle error is not displayed. How can I get the Oracle error when I use my table in Access ?

Thanks for helping me.

(sorry for my poor english)

 

[jdraw]

You might get the underlying Oracle error if you were running a Pass through query. However, since you are using Access syntax in a query against a linked table, the ODBC error is the best you will get.

see the tutorial here for Pass through query.
http://www.techonthenet.com/access/tutorials/passthrough/basics01.php

 

[Stef13]

Thank you very much for your reply.
Unfortunatly, Access will not be used with queries but only with the Access's data grid. I guess I'm stuck...

Anyway, thanks for your help !