Reference a local table in a passthrough query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good Morning,

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

Thanks
 
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
 
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...
 
Back
Top