Oracle ODBC linked records show as #Deleted

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan Loughridge - 27 Feb 2004 22:15 GMT

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

Reply to this Message

CSmith - 29 Feb 2004 07:45 GMT

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.

--
Calvin Smith
http://www.CalvinSmithSoftware.com - Automation Code
http://www.SpanglesNY.com - Fendi, Prada, Von Dutch, etc - 60% off

> My Access 2000 database has ODBC links to tables in an
> Oracle 8i database. One of these tables shows some
[quoted text clipped - 19 lines]
> Thanks,
> Dan

Reply to this Message