[AccessD] Could somebody expand on this a little?

Jim,

The picture becomes clearer.  Thank you.

Steve Erbach

On 1/31/06, Jim Dettman <jimdettman at earthlink.net> wrote:
>
>
>   I don't totally agree with Jim's statement.  Again, you need to be
> specific with what your trying to do and understand what's going on.
>
>   A pass-through query executes entirely on the BE server.  If I'm simply
> trying to fetch records for browsing (ie. open a table or do a simple join
> with no filtering), then a pass-through query makes little sense.  But if
> I'm doing a complex join, filtering, sorting, etc, then it is a performance
> boost to do everything on the server side.
>
>   And if I'm not fetching, but updating or deleting, then they make a lot of
> sense.  Using anything else would be silly.
>
> Jim.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Steve Erbach
> Sent: Tuesday, January 31, 2006 7:38 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Could somebody expand on this a little?
>
>
> Jim,
>
> Thank you.  I've never used them.
>
> Steve Erbach