problem with Oracle linked table to Access

[arcana]

Hi,
I've linked succesfully in a Microsoft Access mdb a oracle table using for 3 times 3 different Odbc driver (Microsoft, Oracle and Easyopen),
but when i try to open this linked table for some records compare #ERROR and Acces give me this message "reserved error -7776, no message for this error".
i've seen that these records have a type field date with null ( for oracle "00-00-0000&quot,
if i make a query without this field, Access show all the records without any error.

can someone help me?
thank you for your interest.

 

[Turkbear]

Hi,
Something is wrong..A NULL Date field in Oracle is not '00-00-0000' it is NULL ( not the same thing)..

 

[arcana]

Thank you Turkbear,
i'm sorry, it's true, the field data in this case is "00-00-0000", but in Microsoft Access causes an error. maybe the problem is referred to the ODBC Driver, i have tried Microsoft ODBC (mdac 2.7), Oracle ODBC Driver and Easysoft Oracle ODBC Driver but without success.
what do you think about?
do you have some suggestion?
hi.