Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Too Much Data??? Oracle --> MS-Access

Re: Too Much Data??? Oracle --> MS-Access

From: Steve Jorgensen <nospam_at_nospam.com>
Date: 1998/09/23
Message-ID: <01bde72f$cb4f6860$9001a8c0@Developer1.intertecservices.com>#1/1

The #deleted# message is not a symptom of a size problem. Though it is not recommended that you open an unfiltered recordset of any table that returns more than a few hundred records, the #deleted# message is not one of the expected symptoms of doing so, slow response and locking problems are.

The deleted message usually appears with attached ODBC tables when the table contains at least one date field or approximate numeric type field ( float or real ). Usually, this field will be in the primary key or the clustered index.

This problem occurs because Access tries to identify a previously accessed record using the primary key data it originally read from the record, but ODBC rounds the data to a different number of binary digits of precision than what the server is storing. When Access tries to look up the record using this data, an exact match is not found so nothing is returned. When no record is returned, Access assumes the record was deleted after the primary key data was fetched.

tlp_at_redrockgrp.com wrote in article <36092CBA.5271_at_redrockgrp.com>...
> Any help on the following is much appreciated!:
>
> I have a back-end Oracle database. I'm trying to "link"
> the (table) data into an Access database.
>
> The table is showing the columns with the data being displayed
> as #deleted#. I've seen this error before for various reasons.
>
> What it is not:
>
> - Permissions on the data are fine
> - I've 'imported' the data into an Access table fine
>
> I've 'linked' in other *smaller* tables. I'm assuming its just
> too much data. Is this a limitation of Access? Memory? Oracle
> or SQL*Net?
>
> I'd like to know if its something I can address or I need to
> find a work-around - importing doesn't seem all that reasonable
> to me..
>
> Again, appreciate any thoughts or info!
>
> --tl
>
> --
> Tracy Lynn Pendergast tlp_at_redrockgrp.com
> Independent Consultant Database Specialist
> (212) 665-2396
>
Received on Wed Sep 23 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US