Microsoft KB Archive/199963

= ACC97: Mail Merge to Word Opens Another Instance of Access =

Article ID: 199963

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



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.

Additional query words: prb

Keywords: kbdatabase kbprb KB199963

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.