Posted by Brad on 07/06/05 14:19

Stu,
Thanks for your response.
The pass-through query is very powerful and it seems that there is a
way to pass it parameters (I haven't figured that out yet) and the
performance was pretty acceptable.

Thansk for the tip.
Brad

"Stu" <stuart.ainsworth@gmail.com> wrote:

>To add to Erland's suggestions, you should also look at Pass-through
>queries in Access; basically, they are a server-side execution tool for
>access. You can use parameters and pass them to stored procedures, but
>you have to do it in code on the Access side. However, it's worth the
>effort.
>
>HTH,
>Stu

[Back to original message]