By default, Word is configured to use the Jet.OLEDB
provider to retrieve records from an Access database. If the Access query
contains the wild card characters "*" or "?" in the criteria, the wild card
characters will be ignored by the Jet.OLEDB provider and no matching records
will be returned. The Jet.OLEDB provider is based on ANSI 92 syntax, which
supports the wild card characters "%" and "_", not the wild card characters "*"
For example, Like "B*" will not work correctly, but Like "B%" will work correctly.
You can use the following options to allow Word to retrieve
the correct records.
Change the criteria from "*" to "%" or from "?" to "_".
Note If the query is being used by Access, make a copy of the query,
change to "%" or "_" in the copy, and then use this copy for merging with
Modify the database to use ANSI 92 syntax. In
Microsoft Office Access 2003 or earlier versions of Access, do this by clicking Options on the Tools menu. Then, click the Tables/Queries tab. On this tab, click to select the SQL Server Compatible Syntax (ANSI 92) check box, and then modify all queries to use "%" instead of "*"
or "_" instead of "?".
Microsoft Office Access 2007, click the Microsoft Office Button, click the
Object Designers tab, click to selct the This database
check box under SQL Server Compatible Syntax (ANSI 92), and
then modify all queries to use "%" instead of "*" or "_" instead of "?".