Unable to view MS Access 2002 parameter query in Word

[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

 

[Van T. Dinh]

I don't think Word MailMerge can use Parameter Queries since there is no way
(AFAIK) that you can enter the value(s) for the Parameter(s) from Word.

One work-around is to use Automation from Access with Word as the Automation
Server and resolve the "Parameters" in the saved Query (so that the Query in
now non-parametrised) before using Automation to run Word MailMerge.