Problem: NULL Oracle Date Fields and Access 97

Here's the problem:

        I linked a Personal Oracle8 table into Access97 through ODBC. The Oracle8 table that I linked into Access97 contains DATE fields and if any of the DATE fields happen to be NULL (i.e. no date entered), then Access97 displays #ERROR on every field of that record. If the DATE fields have values, then the record is displayed correctly by Access97. When I look at the table records using SQL*Plus, all the data is stored properly.

        I think it might be a bug in ODBC.

        Any suggestions or help would be greatly appreciated.

                Mark Received on Fri Dec 05 1997 - 00:00:00 CET