#deleted# showing for all records in Oracle -> Access table
Date: 1999/09/01
Message-ID: <37CDCC2D.D89D87FE_at_istar.ca>#1/1
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 Wed Sep 01 1999 - 00:00:00 CEST