Oracle ODBC linked records show as #Deleted

[Dan Loughridge]

My Access 2000 database has ODBC links to tables in an
Oracle 8i database. One of these tables shows some
records as deleted (all fields contain #Deleted), but
other records in the same table are fine. The records
are all present in Oracle, and all records display ok
from an Access '97 database connected to the same Oracle
table.

The table in question has the following structure:
field_1 - varchar2(20), key
field_2 - varchar2(20), key
field_3 - date
field_4 - char(1)

Field_2 contains encrypted text based on the ISO
character set, so there are many odd characters.

Is there a registry setting or some other configuration
setting that will allow Access 2000 to display all the
records in my table?

Thanks,
Dan

 

[CSmith]

Hi,

Same thing happened to me YEARS AGO when I worked in a similar environment.
If I remember correctly, one desktop had more local and/or video RAM than
the other, which was why the system with lesser memory could not display all
of the records coming down from very large ORACLE datasets. Try pulling only
the data from the field_1 and field_4 columns as a test to see if the
problem continues. Or, only filter by the dates needed to reduce your load
and see if the problem continues. In other words, if you only need first
quarter data, don't query for the entire year.