Access Query as data source

[Larry Mennitt]

Access and Word 2002 sp2.

When I open the merge wizard to select the data source, only some of my
select queries are on the list along with all of the application's tables.
The query designed to supply the desired data works properly when I run it
in Access but is not in the list of queries available for merging with my
Word master document.

I have several other similar query/document combinations that work properly
in the same application. The problem started after doing some minor editing
in the master document.

Larry

 

[Peter Jamieson]

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...