Queries containing user functions not available for Mailmerges in XP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Les Mercer - 30 Jun 2004 13:01 GMT

This works with Access 2000/Word 2000 but fails in 2002 versions.
Word 2002 does not list any Access queries as a data source that contain
references to user defined functions.
Is this a fault or a feature, and if the latter, why?
Is there a workaround?

Les.

Reply to this Message

Peter Jamieson - 02 Jul 2004 00:14 GMT

> This works with Access 2000/Word 2000 but fails in 2002 versions.
> Word 2002 does not list any Access queries as a data source that contain
> references to user defined functions.
> Is this a fault or a feature, and if the latter, why?

> Is there a workaround?

To use Access UDF's, you have to revert to the DDE connection method
(the default in Word 2000, but not Word 2002/2003). In WOrd 2002 you
check Tools|Options|General|"Confirm conversions at open", go through
the connection process again and select the DDE option when prompted.

As far as I know, the reason you have to use DDE is that Access UDF's
can only be executed when Access is running. When you connect using
OLEDB (the default in WOrd 2002/3) or ODBC, only the Jet engine is
running, not the whole Access program. But I don't know for certain.

Peter Jamieson

Reply to this Message

Les Mercer - 02 Jul 2004 11:57 GMT

Thanks Peter, using DDE showed the query with the UDF.
Les.

> > This works with Access 2000/Word 2000 but fails in 2002 versions.
> > Word 2002 does not list any Access queries as a data source that contain
[quoted text clipped - 14 lines]
>
> Peter Jamieson

Reply to this Message

Rate this thread: