I use VB code in Access97 to connect to an Oracle Database. Some tables in the database have Date/Time fields. Retrieving any and all data in the tables works fine UNLESS one of the Date/Time fields is empty. That's when I get the following error:
[Oracle][ODBC Oracle Driver]Invalid date, time or timestamp value. (#0)
Getting this error will not let me return any of the data. The error code breaks and sends me back to the following line of code:
SET recordset = .OpenRecordset()
If my SQL string doesNot try to return the Date/Time field, the code works fine. By the way, if there is a date in the field (for all records that I'm trying to retrieve...not even one empty) then the code will work appropriately and return even the dates.