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

This won't be much help, but I did see that behavior with Access and Oracle.

I don't remember what it was, but in our case, it was something harmless and forgettable. Have the Oracle DBA refresh the indexes on the table for starters. I'll see if I can find the Oracle guru who solved my problem and get back to the NG.

--

Danny Lesandrini
dlesandrini_at_hotmail.com


Brad Aisa <baisa_at_istar.ca> wrote in message
news: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."