Reference a local table in a passthrough query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KeithG - 24 Mar 2006 17:22 GMT

Good Morning,

is it possible to reference a local table in a pass through query? If so can
you show me an example.

Thanks

Reply to this Message

Rick Brandt - 24 Mar 2006 17:27 GMT

> Good Morning,
>
> is it possible to reference a local table in a pass through query? If
> so can you show me an example.
>
> Thanks

No.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

MH - 24 Mar 2006 17:48 GMT

Why would you want to do that?

Pass-through queries are a feature which enable SQL to be "passed" to a DB
Server for execution rather than dragging all the records from the server to
the client and then executing the query. Why not just use a standard query?

MH

> Good Morning,
>
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

Duane Hookom - 24 Mar 2006 17:52 GMT

I suppose you could set up a linked server in SQL Server that references
your Access MDB. Then your SQL Server can include your Access tables in
queries/views...

Signature

Duane Hookom
MS Access MVP
--

> Good Morning,
>
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message