Re: #deleted# showing for all records in Oracle -> Access table

Changes are you have a column in your primary key with an approximate numeric or date/time data type.

Access first reads the primary keys from the table (with some truncation occurring in the ODBC and JET layers) then tries to query each row from the table to retrieve the remaining columns from the table. The where clause Access uses to find a record uses the originally queried primary key values, and converts them to ASCII decimal to do so which cannot always represent the stored binary fraction exactly. When no match is returned, Access presumes the record has been deleted.

Brad Aisa wrote in message <37CDCC2D.D89D87FE_at_istar.ca>...
>Howdy,
>
>We are using Oracle 8.1x and Access 97. I have a whole bunch of tables
>linked to Access. Today, the weirdest thing happened. One of our tables
>shows all data values as #deleted# in Access. I tried deleting and
>relinking the table, and the problem still occurs. The record count is
>correct, but all the data values just have the word #deleted#. I can see
>the data fine using other tools, like TOAD. I can't imagine what is
>causing this. (I also linked the table in another Access database, and
>the same thing happens there too.)
>
>The table is only one of many that have a similar basic key structure
>(three fields) -- the other tables are fine. There is nothing
>particularly distinctive about this table -- it has only about 10
>fields. This was working for weeks, with a lot of update and delete
>traffic, without any problems.
>
>Anyone seen this before? Any idea what is going on?
>
>If you know what is happening, a reply by email would also be
>appreciated: baisa_at_qir.com
>
>Thanks
>
>--
>Brad Aisa
>baisa_at_NOSPAMistar.ca -- PGP public keys available at:
>http://keys.pgp.com:11371/pks/lookup2?op=index&search=Brad+Aisa
>
>"Laissez faire."
Received on Thu Sep 02 1999 - 00:00:00 CEST