Access opens more than once

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

emmy - 05 Feb 2004 13:39 GMT

Hello,
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.
Thanks!
Emmy

Reply to this Message

Cindy M -WordMVP- - 06 Feb 2004 10:54 GMT

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

:-)

Reply to this Message