Re: #deleted# appear when adding similar records!

Dan wrote:

> Any insight would be appreciated...
>
> When we are adding records to a simple table (3 fields of 1 is a
> primary key with a sequence used in the programmed trigger), access
> show the newly added records as #deleted#. If I insert different
> values like below:
>
> TTT
> SSS
>
> It is OK, but when I insert the same value like below:
>
> TTT
> TTT
>
> Access get messed up and show the record as #deleted#. In SQL*Plus,
> newly added record appear there with no problem. Also, if I close my
> table and re-open it again, all my data appear OK.
>
> We are using Access 2002 with an Oracle 8i database (Oracle ODBC
> v8.1.7 I think - or one of the latest for 8i)
>
> Thanks for your help!
>
> Dan

I would explore using other ODBC drivers and go to Oracle's web site and see if there is a more recent driver there.

Daniel Morgan Received on Sun May 12 2002 - 05:57:33 CDT