Solved

Question on Pass-thourgh query capabilities...

Posted on 2008-10-24
5
293 Views
Last Modified: 2012-06-21
I want to run a pass-through query because it will run SQL faster on the server.  However i want to use the results returned to make a new table in CURRENT datatbase and not on the sever as i do have permissions want the table locally.  

how do i get the Insert into to create a table in the current db
0
Comment
Question by:david_88
  • 2
  • 2
5 Comments
 
LVL 18

Accepted Solution

by:
jmoss111 earned 250 total points
ID: 22795364
Use the pass through as source for a make table query
0
 

Author Comment

by:david_88
ID: 22796312
does that mean i have to create 2 querys 1 for the pass-through and then 1 for the make table?

thanks
d
dave
0
 
LVL 18

Expert Comment

by:jmoss111
ID: 22797681
That would be correct
0
 
LVL 11

Assisted Solution

by:datAdrenaline
datAdrenaline earned 250 total points
ID: 22798758
If you want, you can just create ONE Query and utilize an ODBC connection string inside of the Make table SQL Statement ... how complex is your PT query? .. can you post the SQL statement for it?
0
 

Author Closing Comment

by:david_88
ID: 31509609
got it to work both ways many thanks :)
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question