Unable to see MS Access Query in Word 2002

[Timothy LoGrasso]

I am trying to mail merge from Word 2002 to a parameter
query in MS Access 2002. This DB exists entierly of
linked tables from a postgres DB and this one query. When
I open this DB it gives me an Alert stating "This data
source contains no visible tables." When I click OK,
another alert pops stating "Unable to obtain list of
tables from the data source" I then see a Select Table
window, where I can click options and see views, synonyms
etc. If I click them all I still cannot see the query.

Question: How to I make this MS Access Query visible to
MS word?

--Tim

 

[Peter Jamieson]

Typically the OLEDB connection that Word tries to make by default
a. cannot "see" linked tables and
b. cannot "see" queries which have certain characteristics, e.g. parameter
queries

If your query falls into category (b) then Word will stop trying to open the
..mdb using OLEDB and will automatically try ODBC. ODBC would typically "see"
all the linked tables and a larger class of queries, but you do have to
check the various options to see views etc. as you suggest. But the other
problem with the ODBC table/view selection dialog box is that when it is
first displayed you cannot guarantee that the database you first specified
is actually the one currently selected in the dropdown list at the bottom of
the dialog. You sometimes have to select the database in there. Further, it
is very difficult to select the correct database if the database pathnames
are long since there does not seem to be a way of seeing the right had endof
the path name. So keep the path names short if possible.