ACC97: Mail Merge to Word Opens Another Instance of Access (199963)


The information in this article applies to:

  • Microsoft Access 97
This article was previously published under Q199963
Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

When you perform a mail merge to Microsoft Word 97 from Microsoft Access 97, a second instance of Microsoft Access 97 opens.

CAUSE

A second instance of Microsoft Access 97 opens if either of the following conditions is true:

You have a custom application title set on the database.

-or-

There is a value other than "Microsoft Access" in the Titlebar entry of following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Run-Time Options

RESOLUTION

There are three methods that can be used to resolve this issue:

Method 1
Remove the Contents of the Application Title Property in the Startup dialog box

  1. Start Microsoft Access.
  2. Open the database that you are using in the mail merge.
  3. On the Tools menu, click Startup.
  4. Remove any text in the Application Title box. Click OK.
  5. Perform the mail merge.

Method 2
Use ODBC from Word to Connect to the Access Database

  1. Start Microsoft Word.
  2. Open the document that you are using in the mail merge.
  3. On the Tools menu, click Mail Merge.
  4. In the Mail Merge Helper dialog box, click Create, and then click Form Letters.
  5. Click Active Window.
  6. Click Get Data, and then click Open Data Source.
  7. Click to select the Select Method check box.
  8. In the Files of Type list, click Microsoft Access Databases (*.mdb).
  9. Click your database, and then click Open.
  10. In the Confirm Data Source dialog box, click MS Access 97 Database via ODBC (*.mdb), and then click OK.
  11. Select the table or query that you are using for the mail merge, and then click OK.

Method 3
Remove the Text from the Titlebar String Value of the Registry

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
  1. Click Start, and then click Run.
  2. In the Open box, type regedit.
  3. Locate the HKEY_LOCAL_MACHINE registry folder.
  4. Expand the HKEY_LOCAL_MACHINE folder until you locate the SOFTWARE\Microsoft\Office\8.0\Access\Run-Time Options folder.
  5. Double-click the Run-Time Options folder to view its contents.
  6. Select the Titlebar entry, and then, on the Edit menu, click Modify.
  7. In the Edit String dialog box, remove all text from the Value Data box. Click OK.
  8. Click Exit on the Registry menu.

MORE INFORMATION

During a mail merge, Microsoft Word initiates a DDE session from Word back to Microsoft Access. When using DDE, Microsoft Word is looking for "Microsoft Access" in the application title of the Access window. If the application title is anything other than "Microsoft Access," Word starts a new session of Access.

Steps to Reproduce the Behavior

  1. Open Microsoft Access 97.
  2. Open the sample database Northwind. The Northwind database is typically located in C:\Program Files\Microsoft Office\Office\Samples.
  3. On the Tools menu, click Startup.
  4. Type MyDb in the Application Title box. Click OK.
  5. In the Database window, click the Tables tab.
  6. Click the Customers table.
  7. On the Tools menu, point to Office Links, and then click Merge It with MS Word.
  8. In the Microsoft Word Mail Merge Wizard dialog box, click Create a new document and then link the data to it. Click OK.
Note that a new session of Microsoft Access opens on the workstation.
Modification Type:MajorLast Reviewed:10/22/2003
Keywords:kbDatabase kbprb KB199963
©2003 Microsoft Corporation. All rights reserved.