Using a PassThrough Query to Make a Table

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top