Re: Oracle ODBC linked records show as #Deleted

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: CSmith (NoEmailNeeded_at_none.com)
Date: 02/29/04 

Date: Sun, 29 Feb 2004 02:45:01 -0500

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
"Dan Loughridge" <dan.loughridge@usa.xerox.com> wrote in message
news:34a701c3fd7f$38e6a760$a501280a@phx.gbl...
> 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

Relevant Pages

  • Re: need help on cgi to get multi pages and could sort by column from Oracle
    ... the view could sort by column and could display by multi pages. ... Are you an Oracle developer that uses Perl, ... the CGI server or the Oracle server? ... What if a database entry that is ...
    (comp.lang.perl.misc)
  • ODBC linked records show as #Deleted
    ... Oracle 8i database. ... The records are all present in Oracle, ... character set, so there are many odd characters. ... Is there a registry setting or some other configuration ...
    (microsoft.public.access.security)
  • Oracle ODBC linked records show as #Deleted
    ... Oracle 8i database. ... character set, so there are many odd characters. ... Is there a registry setting or some other configuration ...
    (microsoft.public.access.externaldata)
  • what to do with a table called EVENT ?
    ... I'm writing a VB.NET 2005 app to display some data from an Oracle 10g ... database that has a table called EVENT. ...
    (microsoft.public.dotnet.framework.adonet)
  • Getting The Performance Slower
    ... After Installing Oracle Developer Forms 9i with Oracle 10G database on ... Windows 2000 Server, ... results display on it for a particular query. ...
    (comp.databases.oracle.tools)