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

You asked for 'any ideas'. :,) Are you connecting with ODBC? I saw this once with an Access/DB2400 connection. I had to tweak the parameters on the driver to get it cleared up. I don't remember exactly what it was, but you might start by testing the authority section.

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