Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Merge Template losing its data source (2000 SR-1)

    <P ID="edit" class=small>(Edited by jscher2000 on 11-Jun-03 23:04. Subject line made more descriptive to invite more lookers.)</P>This question may have been addressed before, but I've checked all of the recent Word and Access Posts and haven't found an answer to this problem. I work at a law firm that has migrated from Word 95, to Word 97 and we are now using Word 2000. For this reason, many of our documents and templates have been created in prior versions of Word and we will continue to use them when we upgrade to Word 2002 next month.

    We have numerous Word merge templates, that we use to create corporate document packages. Each Word merge template is linked to its own Access database. When we open the Word template (through Docs Open) Word remembers that it is a template, displays the merge tool bar, initiates the DDE and then opens the corresponding Access database. I created a few of these templates myself, and I don't remember doing anything in particular to make Word save the document as a merge document, link it to the Access database, remember its location and open access with DDE. All of this information and corresponding links was saved with (or within) the merge document template.

    Although this information still works on all of the existing databases, I have recently (in March) created two new merge templates, and Word is not saving any of the merge information. It does not save the document as a merge document, nor does it use DDE to open the corresponding Access database. I have searched through the Knowledge base articles and have not been able to find anything that specifically addresses this problem. I suspect it is related to the SR-1 update because I believe I did not have this problem until it was recently installed. Do you know why this is happening? Can you tell me how to make Word store the document as a merge document and save the data source information? <img src=/S/bwaaah.gif border=0 alt=bwaaah width=123 height=15>

  2. #2
    New Lounger
    Join Date
    Feb 2003
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merge Template losing its data source (2000 SR-1)

    I kept playing with this after I posted the problem. I couldn't get it to work. So, I started from scratch again, using the active window to create a merge document. Then, I inserted a copy of the original merge document into the active document (using Insert, File), but only after Word created its links with Access (and when I received the prompt to set up the main document). This time it saved the document as a merge document and remembered the links to Access, exactly the way it was supposed to have done in the first place. After all is said and done, I guess the only explanation is that my original merge document became corrupted somehow. Thanks for your assistance, and I hope this helps anyone else who runs into this problem. I'm going to re-do my other merge template that's giving me the same problem.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Merge Template losing its data source (2000 SR-1)

    One other possibility exists - someone may have opened the document and not been able to complete the merge for whatever reason, and then told Word to remove all the merge information. When it does that, the field information is still there, but the link to a data source and the indication of it being a merge document are removed. We've chosen to use automation from Access in most cases, and actually remove the data source from the document, but retain it's main merge document status, and then set the data source from the Access database. That way if it is necessary to move the databases, we can simply change the code (actually the data is stored in an Access table), and we don't have to fight with each individual document to find the data source and resave the merge document.

    BTW, changes in Word 2002 (XP) may cause you some grief if you are using queries for your data source if you eventually upgrade to it.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •