Can you read a make table in a pass through query?

[Jim Moberg]

Hi,

I am learning how create pass through queries and am currently working on
converting a query I had created using the design mode to a pass through
query. The query I created using the design mode reads a table made from a
previous query. The make table is stored in the Access mdb file and I'm not
sure if I can read from it and how to do so.

All of the the other tables are stored in SQL Server and I can read them
just fine. I don't have permissions to write to the database that's in SQL
Server.

Is it possible to read from the make table and join it to the tables that
are in SQL Server? If so then what is the syntax. I looked all over and
couldn't find anything on this.

 

[Jeff L]

Not via a pass through query. Pass through queries only work with data

 

[Jim Moberg]

What are my options then? The query I'm using is reading a make table in
Access which is created from three different queries. it's the only way I
can get the subset of data I need to generate the needed records.

Would subqueries be an option?

 

[Jeff L]

You should be able to link to your tables via ODBC and run your queries
as you would with any other tables.

 

[Jim Moberg]

If you are talking about linking to the tables in SQL Server I have already
done that. The reason I am working with the pass through queries is because
some of the queries running off of the linked tables run awfully slow. I'm
talking in the order of hours here.

The pass through queries run much faster. When I talk about running queries
from the linked tables I'm talking about creating the queries using the
design mode of access. If I misunderstood what you suggested then please let
me know. Thanks!

 

[Jeff L]

Yes, I understand that the pass through queries run much faster, but in
order for you to run a query using a local table you would have to do
it the way I suggested, by linking to the tables in SQL Server and
creating your queries that way.

Perhaps another solution:
You can run "make table queries" on SQL Server but you need write
access to do that. Is getting write access from your database
administrator an option?

 

[Jim Moberg]

I highly doubt that I will be able to get access to do that. Thanks.