Solved

Question on Pass-thourgh query capabilities...

Posted on 2008-10-24
5
289 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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

707 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now