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

Hello Tracy,

We use Access with an Intersolv ODBC driver that connects to an Oracle 7.3.2 database. We get the same #DELETED# in the Access linked tables but we add a Workaround to the registry on each machine to fix it. For our system we make the following registry edit.

HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\dsnname "WorkArounds"="65536"

Don't know if this will help you. You may have to contact the ODBC driver vendor. I think that's who gave us the fix.

Matthew MacFarland
matthew_macfarland_at_dril-quip.com

tlp_at_redrockgrp.com wrote in message <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