By default, Word XP connects to Word using OLEDB and using that connection
method will not display several types of query, including
a. parameter queries (where /Access/ asks you for the values of various
parameters when you execute the query. But OLEDB does not need to run Access
to get its data)
b. queries containing user-defined functions (i.e. written in Access VBA) -
again, Access has to be running to execute these)
c. UNION queries (and probably UPDATE and INSERT queries)
d. queries containing certain predefined VBA functions. I don't know why
some are not "recognised" when most are.
In most cases you can get Word to "see" the query by checking Word
Tools|Options|General|"confiirm conversion at open", going through the
connection process again, and selecting the DDE option when it is offered.
But that starts a copy of Access...
