SQL Passthru

S

Steve

Can I get confirmation that an SQL Passthru query will
bypass the jet engine.
I'm having performance issues and I think it is because
the query in question combines a passthru (to oracle)
and an access query and the jet engine bogs everthing
down. If I can bypass the jet engine by having absolutely
everything in a passthru I should be OK.
Sound correct??

I'm using Access 97 as FE and Oracle 8 as BE.
 
V

Van T. Dinh

Pass-Through Queries are processed by the Server specified by the Connection
String, not JET.
 
G

Guest

Yes but with mixed results.
If the theory is correct, it is fine-tuning of the SQL
code that is needed and not due to the jet engine.
Thanks for the help.
 
Top