<div>
does that mean i have to create 2 querys 1 for the pass-through and then 1 for the make table?<br />
<br />
thanks<br />
d<br />
dave
</div>


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

thanks
d
dave

<div>
got it to work both ways many thanks :)
</div>


<div>
<div class="content wysiwyg-content">
I want to run a pass-through query because it will run SQL faster on the server. &nbsp;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. &nbsp;<br />
<br />
how do i get the Insert into to create a table in the current db
</div>
</div>


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

Question on Pass-thourgh query capabilities...

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.