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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle and Access

Re: Oracle and Access

From: Mark Hannay <mhannay_at_cartech.com>
Date: Thu, 28 Jun 2001 15:22:17 -0400
Message-ID: <3b3b8494$1_1@news6.fast.net>

Sean Keplinger wrote in message ...
>vidas <vidasm_at_yahoo.com> wrote:
>One thing to note using Oracle linked tables in Access: If you run an
>Access query on an Oracle linked table, then Access must pull the entire
>table in order to run the query. In short, it's slow and eats network
>resources.
>
>If you want to run queries against Oracle data in Access, use the
>"pass-through" query option. It will save you headaches.

I don't think so. I run Access queries against linked Oracle data all the time and performance is fine.

Mark Received on Thu Jun 28 2001 - 14:22:17 CDT

Original text of this message

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