When you use Access as a data source some query types will not be listed,
e.g.
a. parameter queries (i.e. ones where Access would prompt you for a value)
b. queries that contain functions written in Access VBA
c. queries containing one of the financial series functions (most of them
anyway)
d. queries containing one or two other Jet/ACE SQL functions that are for
some reason not recognised by Jet/ACE OLE DB (perhaps the replace()
function, for example)
e. Union queries
f. perhaps queries that get their data from cedrtain types of linked table.

Some queries may be visible but won't return any data, e.g. queries that use
* and ? as wildcards rather than % and _ (and by default, that would be
/all/ queries that use wildcards in a database created in Access 2007).

That's all true of Access 2003. Most of the same things are /probably true
of Access 2007, and there could also be other restrictions.

From Word, you get to see most queries if you choose the DDE connection
method (you have to go into Word 2007's settings and check something like
"Confirm conversions at open" - That's actually the Word 2003 description of
the option as I haven't got the Word 2007 one to hand. But DDE has other
problems (it has to open Access, doesn't retrieve Unicode text, and possibly
other stuff I don't know about in Access 2007.

Peter Jamiesonb