Queries missing from Access data source list

[george atkins]

When creating a Word mail merge (in Office 2003) to an
Access database, I do not see the entire list of queries.
In fact, after listing about seven tables and "views", the
list stops. The database has about 50 queries in it.

I started with an Access 2000 database, then converted it
to a 2002-2003 format. Same results.

Has anybody seen this behavior?

TIA!

 

[Peter Jamieson]

Word does not "see" certain types of query when it connects to the database
using OLEDB, which is the default connection method in Word 2002 and later.
In particular, it does not "see" UNION queries, parameter queries, queries
containing a coiuple of "rogue" financial functions, and (AFAICR) queries
containing user-defined functions. If the missing queries are those sorts of
query, that is probably the explanation. If you chnage the connection method
to DDE (check Word Tools|Options|General|"Confirm conversions at open", go
through the connection process again, and select DDE when offered, you
should see all the tables and queries. You will certainly need to use DDE to
use parameter queries, but some of the others may be accessible if you try
connecting via ODBC.