Oracle connection

[Flopper]

Greetings,

I'm attempting to create Linked Oracle tables in Access but i'm having a number of problems with performance, especially when running queries. At present i'm retrieving the tables using a Microsoft ODBC driver as queries would time out using the Oracle ODBC driver.

The queries i'm requesting are simple. I'm a Crystal developer and find that running the same query through Crystal using a native connection is much quicker. Therefore i presume the ODBC layer is slowing down the Access query. Is it possible to link Oracle tables in Access using a native connection rather than ODBC?

Any help would be greatly appreciated.

 

[PHV]

You may also consider PassThru queries.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Flopper]

Apologies,

I'm using Access 2000 and the Oracle ODBC driver is 8.00.510.00. The Microsoft driver is 2.573.6200.00.

Cheers

 

[cmmrfrds]

If you do not need to link (join) Oracle tables to local Access tables then use pass-thru queries. If you need to join the local tables then consider pushing the local data down to Oracle or creating Linked Servers on the Oracle side to your local tables, then using pass-through queries. Bottom line is that large linked tables will be slow to work with.