It can depend upon the driver. I was working in Access once and did a query
with 1 driver and it took maybe 1 or 2 seconds to get my results. I
switched drivers and did the exact same query and after 45 minutes (and lots
of local disk activity) I finally got the same results. When I switched the
bad driver to pass thru it took under 2 seconds.
Jim
"Mark Hannay" <mhannay_at_cartech.com> wrote in message
news:3b3b8494$1_1_at_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 - 21:29:51 CDT
