[SAC]

I'm using Word 2003.

When selecting data sources for a letter, I select an Access database, but
not all the queries show up after that. How can I get them to show for
selection?

Thanks for your help.

[Peter Jamieson]

Some query types won't show (Union queries, and Parameter queries) when
you connect with the default method in Word 2003, which is OLE DB.
Typically you have to revert to the old DDE method (check Word
Tools-Options-Confirm conversion at open, then go through the
connection process again, and select the DDE option in the extra Confirm
box that appears). If you are in a position to modify the database, you
may be able to get some queries to run by wrapping them in a another
query that simply does

SELECT * FROM thequerythatOLEDBdoesnotsee

The problem with parameter queries OLE DB is that OLE DB itself has no
mechanism to prompt for the parameters, and nor does Word - with DDE,
Access does it. To work around that, you have to use e.g. Word VBA to
set up the parameters (prompting if necessary) then either generate the
SQL text that the Query would issue, or use a special technique to run
the query from Word VBA. I've never tired it for real, and it wouldn't
surprise me if Microsoft hadn't blocked that particular option since I
last looked.

Peter Jamieson

http://tips.pjmsn.me.uk

SAC wrote:
I'm using Word 2003.

When selecting data sources for a letter, I select an Access database, but
not all the queries show up after that. How can I get them to show for
selection?

Thanks for your help.