Solved

Question on Pass-thourgh query capabilities...

Posted on 2008-10-24
5
294 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
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…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

732 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