Hi Emmy,
I have a word document that is merged to a query in
access. Every time I open the mail merge helper and
change the query options, it opens another instance of
the database.
OK, I assume this is Word 97 or Word 2000?
this is a common occurrence when DDE is used to connect to
a data source. DDE is the default in those two versions of
Word.
There are various things that can cause the problem, but
most common is that you've assigned a "pretty name" to be
displayed in the database's title bar. If you remove that,
the behavior *may* disappear.
Another possibility would be to use ODBC to connect to the
data source, instead. You need to be aware, however, that
date and number formatting would not necessarily come
across this link. In order to select ODBC as the connection
method, activate "Select method" in the Open Data source
dialog box.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
