MS Query via MS Access query

[richand1]

Hi All

I'm having a bit of a problem with Microsoft Query:

I can return data from a database if I select a table but, for some reason that is beyond me, if I select * from a select query in the same database, MS Query returns nothing but the field names. It doesn't produce any error messages.

I have checked that the query works in the database, and it does; I have increased the timeout period of the link, and still nothing.

Does anyone have any ideas?

Thanks
Rich

 

[PHV]

Is by chance the query a parametized one ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[richand1]

I've got criteria on a couple of the fields on the Access side, but no criteria at all in the MS Query.