Mail Merge Linked To Query Using Wildcards

[Jon Bone]

Hi All,

Since upgrading to office xp I have been having problems with word mail
merges linking to queries using wild cards as part of the parameters. (All
databases are saved in 2000 format)

I have a query similar to "SELECT * FROM Table1 WHERE Name LIKE 'Smi*'",
when this is opened in access a number of rows are returned, however when
you use the same query as a datasource for a word merge word reports that
there are 0 rows returned.

I would be grateful for any assistance you can give.

 

[Cindy Meister -WordMVP-]

Hi Jon,

This has to do with the new default connection method, OLEDB. OLEDB works
with a different SQL language standard (ANSI-92) that uses different symbols
for wildcards.

Your database was created using ANSI-98. Access can work with both. OLEDB
can't. So you probably want to use a different method to link in the data.
Go to Tools/Options/General in Word and activate "Confirm conversions on
open". Now when you select the *.mdb file you'll get a list where you can
choose DDE or ODBC instead of OLEDB.

Since upgrading to office xp I have been having problems with word mail
merges linking to queries using wild cards as part of the parameters. (All
databases are saved in 2000 format)

I have a query similar to "SELECT * FROM Table1 WHERE Name LIKE 'Smi*'",
when this is opened in access a number of rows are returned, however when
you use the same query as a datasource for a word merge word reports that
there are 0 rows returned.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail