Queries containing user functions not available for Mailmerges in XP

[Les Mercer]

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.

 

[Peter Jamieson]

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

 

[Les Mercer]

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