ACC97: Mail Merge to Word Opens Another Instance of Access

ID: Q199963

The information in this article applies to:

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

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 ways 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 click OK.


Method 3: Remove the Text from the Registry's Titlebar String Value

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the "Changing Keys and Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete Information in the Registry" and "Edit Registry Data" Help topics in Regedt32.exe. Note that you should back up the registry before you edit it. If you are running Windows NT, you should also update your Emergency Repair Disk (ERD).
  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 will start a new session of Access.

Steps to Reproduce Behavior


  1. Open Microsoft Access 97.


  2. Open the sample database Northwind. It is usually 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.

Additional query words: prb 


Keywords          : kbdta IntpPrtm kbDatabase kbODBC 
Version           : WINDOWS:97
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 6, 1999