I am confused

G

Guest

Hi,
I want to know the different between Pass-Through Query / Create a link
table / ADP File

from a help file, I understand the Pass-Through Query send commands directly
to an ODBC database server that doesn't need Jet engine process the data.
How about if I create an ODBC linked table, when i open the table, does it
use Jet Engine? How about a ADP file, it uses Jet Engine as well (I don't
think ADP does)?
and I would like to know which one processes the data faster

Thanks for the explaination.

Ed
 
D

Duane Hookom

Linked ODBC tables allow you to easily combine the usage of Access tables as
well as linked ODBC tables. An ADP doesn't use Jet as connections are made
directly to the SQL tables/views/stored procedures...

You can't edit the records returned by a P-T query.

Any one of these can be faster or slower than the others. If you don't need
Access/Jet tables, consider creating an ADP.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Table Query to external ODBC SQL Server database 17
Microsoft Jet Database engine does not recognise... 0
crosstab query with parameter query 5
Pass through query to oracle db 2
query links to SQL server and mdb table 1
Pass Through Queries (Access 2002) 2
Optimization of Between Clause Queries 3
ODBC Pass-through query with parameter from table 5

Top