Re: Oracle and Access

vidas <vidasm_at_yahoo.com> wrote:

> Linking tables in Access seems to be not the best solution - those
> tables are already linked (are being updated) from other Access
> databases (one access mdb acts like a major database, other mdbs - as
> clients).
> Via ODBS this process tends to be very slow.

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.

HTH,
Sean

-- 
  __ _
 /  ('>-  Sean Keplinger             | $ man life
 \__/     skeplin at one dot net     | No manual entry for life
  L\_     http://w3.one.net/~skeplin |