Re: Extra Access Instance with Automated Mail Merge

From: Neil Ginsberg (nrg_at_nrgconsult.com)
Date: 12/18/04

  • Next message: Neil Ginsberg: "Re: Extra Access Instance with Automated Mail Merge" 
    Date: Sat, 18 Dec 2004 09:28:48 GMT

    Hi, Cindy.

    "Cindy M -WordMVP-" <C.Meister-C@hispeed.ch> wrote in message
    news:VA.0000a4e2.00e7f672@speedy...
    > Hi Neil,
    >
    >> I also tried using ODBC when connecting the data source, instead of the
    >> default DDE. The results were the same.
    >>
    > This is not possible. DDE always runs the application; ODBC never touches
    > the application, only the data. Might there be something in the mail merge
    > document that's maintaining a DDE connection (a DATABASE field?)

    I meant that I used ODBC instead of DDE for the data connection, not to run
    the application.

    In http://support.microsoft.com/?kbid=285332, the article spells out three
    data access methods for automated mail merge in Word 2002: OLEDB (the
    default), ODBC, and DDE. I was noting that I had tried all three.

    >
    > Are you certain the document is not connected to the database (via DDE)
    > when it's opened? If it is, it will connect to Access, and changing the
    > connection later won't "make it not have happened".

    I'm not sure I'm following you here. The document is "connected" to the
    database when it is opened (since it uses the database as its data source).
    However, the database that's opening the Word doc is also the database that
    is used as the data source, so there's no need for a second instance of the
    database to be opened.

    Indeed, when I run the application in Access 2000, I don't experience the
    phenomenon. However, when a user runs it in Access 2002, a second instance
    of the database is opened and is visible to the user. Usually this second
    instance is closed when the Word document is closed. However, it is common
    for the *calling* instance of the database to be closed and the new instance
    to remain open when the Word document is closed!

    >
    > Are these documents that were created in Word 2002, or in an earlier
    > version?

    Word 2002.

    > And...
    >
    > <<However, when a user uses it in Access 2002 and Word 2002, an extra
    > instance of the Access application is opened and remains open at the end.
    > Sometimes it remains open and the calling application is closed!>>
    >
    > Have you very carefully checked your code to make sure you're not opening
    > and/or closing the database?

    Yes, positive.

    > Perhaps even using something with .Close or
    > .Exit without specifically saying where it should take place?
    > (Application.Exit instead of wdApp.Exit, for example)

    When I close Word, I am using:

        objWord.Application.Quit wdDoNotSaveChanges

    Do you prefer a different method for closing Word?

    Thanks,

    Neil

    >
    > Cindy Meister
    > INTER-Solutions, Switzerland
    > http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
    > 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 :-)
    >

  • Next message: Neil Ginsberg: "Re: Extra Access Instance with Automated Mail Merge"

    Relevant Pages

    • Re: Word could not reestalish a DDE connection to ACCESS DB
      ... the .mdb /wherever it is/ When the Select Data Source dialog box opens, ... conversion at open" is checked) you should see the DDE option and you should ... When you make a connection to a data source in Word, ...
      (microsoft.public.word.mailmerge.fields)
    • Re: Word could not reestalish a DDE connection to ACCESS DB
      ... "Peter Jamieson" wrote: ... that the connections are DDE - in Word 2003 it's more likely that they ... When you make a connection to a data source in Word, ...
      (microsoft.public.word.mailmerge.fields)
    • Re: Access/Word 2007 Mail Merge
      ... have thought that they would have occured earlier in the connection process. ... specify DDE, I always get the DDE dialog. ... might be "unusual" about your database, its location, etc. ... This isn't quite what I normally see either: Queries with joins are ...
      (microsoft.public.word.mailmerge.fields)
    • Re: Word 2003 Closes upon update of sort order of table using Acce
      ... "Peter Jamieson" wrote: ... within the database name text box. ... let's step through the basic approach needed to make the connection ... start the process of connecting to a data source ...
      (microsoft.public.word.mailmerge.fields)
    • Re: Mail Merge to Word 2007 from Access 2000
      ... if your data source is a table in Access, or a query that is not a parameter query, and a few other "if"s, you may be able to connect using OLE DB, which is the current standard and may work around many of these problems. ... However, to do that with a database that has a login/password, you will need to set up an "Office Data Connection" file that contains the necessary info. ... For the answers to your questions: c. Has your Windows system been upgraded as well as your Office system? ...
      (microsoft.public.word.mailmerge.fields)
    Loading