Queries missing from Access data source list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

george atkins - 31 Aug 2004 15:56 GMT

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!

Reply to this Message

Peter Jamieson - 04 Sep 2004 09:13 GMT

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.

Signature

Peter Jamieson

> When creating a Word mail merge (in Office 2003) to an
> Access database, I do not see the entire list of queries.
[quoted text clipped - 7 lines]
>
> TIA!

Reply to this Message

Rate this thread: