Using a PassThrough Query to Make a Table

G

Guest

I'm trying to use a PassThrough Query to make a table from the data returned
however the database the query is executed against thinks I'm trying to
create a table on this database and not on the Access Database where I'm
runing the query from. I don't have permission to carry out such a task on
this database. How can I get my PassThrough Query to make my table ?. I've
tried the PassThrough as a normal select query and then run an append query
on the first query but this second query just hung wwith no results returned
 
M

[MVP] S.Clark

I think you need to add an extra step between the two. So, make the PTQ
just a select query. Then use the PTQ as the basis for a make table query
in Access.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

Conor Walsh said:
I'm trying to use a PassThrough Query to make a table from the data returned
however the database the query is executed against thinks I'm trying to
create a table on this database and not on the Access Database where I'm
runing the query from. I don't have permission to carry out such a task on
this database. How can I get my PassThrough Query to make my table ?. I've
tried the PassThrough as a normal select query and then run an append query
on the first query but this second query just hung wwith no results
Click to expand...
returned
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passthrough query 3
Using Passthrough Query to Disable Triggers 4
Parameters, Passthrough UpdateQueries, and SQL 6
passthrough query referencing a saved table 1
Linked table query 3
SQL query 1
Max SQL length for Passthrough Query 2
Make-table query freezing 5

Top