Jim,
A pass-through is typically much much much more efficient than an Access query.
P-T queries are read-only which might be a valuable feature.
A P-T uses the SQL syntax of the database server so functionality like calling stored procedures, using CTEs, recursion, and other cool stuff that isn't available in Access queries.
P-T queries aren't editable and can't take advantage of data not on your server (without a lot of work). There typically isn't a crosstab equivalent in most databases (again without a lot of work).
Duane Hookom MVP
MS Access
----------------------------------------
> From: luvmymelody@yahoo.com
>
> Hello,
>
> So I have been researching pass-through queries and I cannot find anything that says why you should create a pass-through query. The only things I find is how to create the query. What is the difference between a pass-through query and a regular linked table?
>
> Thank You
>
> Jim Wagner
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar