Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle and Access
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
![]() |
![]() |