Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ODBC ACCESS97/ ORACLE AND DATES
I think that assign the default value on the date column will solve the
problem.
gerard wrote in message <376D83B1.4A82_at_xsoft.demon.co.uk>...
>Has anyone experienced this problem.
>
>We have MS Access97 connected to Oracle 8 using ODBC.
>A column in Oracle is of type DATE.
>An access field is bound to this column. If you enter a date into
>this field all is ok. You can go back to the field and change the date
>with no problem. But if you delete the date, move out of the field and
>then back into the field again, a garbage date appears, usually
>01/11/20. You then can't delete this date at all. You get a dialogue
>box that tells you that someone else has changed the data.
>The only way to remove this garbage date is through SQLPLUS.
>On a date oriented app this bug is most infuriating, and I can't see
>any way of tracking down where the fault lies.
>
>Help please
>
>regards gerard
Received on Mon Jun 21 1999 - 12:38:01 CDT