#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Jan 2007
    Location
    Calgary
    Posts
    20
    Rep Power
    0

    Question Mail Merge Issue - How to Prevent Word from closing Access Database


    I am using Microsoft Office 2013. I have mail merge documents set up in Word that are linked to an Access query via DDE. The problem I am having is that when I close the mail merge document, it closes the database. This is an issue for a couple of reasons:

    1) I have other documents to merge, and it is a pain to have to keep opening the database each time. Word used to open the database on its own, but does not do that in this version;

    2) Some of the merge documents are linked to queries that use data from unbound fields in a form as criteria for the query. Every time it closes I have to re-select my criteria options (it is a shared multiuser database, so I don't want to use a form that is bound to a table).

    Even if I open up multiple mail merge documents that use the same database as a source, if I close the initial mail merge document, it closes the database.

    Does anyone has a fix/solution to this?
  2. #2
  3. Moderator
    ASP Super Genius (4500 - 4999 posts)

    Join Date
    Apr 2009
    Location
    The Great Land
    Posts
    4,626
    Rep Power
    653
    Not finding much on this issue but here is one Mail Merge Crashes Access and another Another Mail Merge Crashes Access

    Have to ask - Why mail merge and not Access report?

    Database is multi-user, split design? Use a 'temp' table for user criteria (table is permanent, data is temporary). Temp table goes in frontend and since each user should run their own copy of frontend, each user has a table for their own use and won't conflict with other users.
    Last edited by June7; April 10th, 2017 at 03:33 PM.
    I like to know if my suggestion helped you. One way to let me know is by clicking star at bottom left corner of post.
    Debug!Debug!Debug!http://www.cpearson.com/excel/debug.htm

Similar Threads

  1. How to stop Word Mail Merge from closing the datasource
    By pebbleslr in forum Microsoft Access Help
    Replies: 0
    Last Post: February 26th, 2014, 10:35 AM
  2. Some advide - Access to Word Mail Merge
    By elenton in forum Microsoft Access Help
    Replies: 3
    Last Post: November 27th, 2006, 06:30 AM
  3. Mail merge in word
    By database in forum Microsoft Access Help
    Replies: 1
    Last Post: July 7th, 2004, 06:40 PM
  4. running a word mail merge through access
    By RdKirb49 in forum Microsoft Access Help
    Replies: 5
    Last Post: July 1st, 2004, 09:30 AM
  5. Using Access to run Word Mail merge
    By RdKirb49 in forum Microsoft Access Help
    Replies: 5
    Last Post: June 25th, 2004, 09:21 AM

IMN logo majestic logo threadwatch logo seochat tools logo