DDE Word 2000 sp3 -> Access 97

Posted on 2006-04-05
Last Modified: 2013-12-27
Dear all    
I'm tring to merge a microsoft word 2000 model from an Access 97 database. After merge operation, when I open the microsoft word template, it  
hung up "Waiting for Microsoft Access to Accept DDE Commands".  
In the background Microsoft Access opens, but nothing else happens. The word document is in 2000 SP3, and the Access database is 97.  
.. It's strange ... with Word SP 1 works correctly! :-(
What can I do??

Question by:pzilioli
    LVL 44

    Expert Comment

    Hello pzilioli,

    this could be an access setting
    1. goto tools | options
    2. click the advanced tab
    3. uncheck the box to "ignore DDE requests"

    but as you said it works in Word SP1, can you set up a new document with a test merge that works?
    and how did you set up the merge with a table or a query, does changing this make a difference?

    i read one post that installed office clean to solve this, but that would be a last resort

    hope this helps a bit

    Author Comment

    1) DDE requests are enabled...
    2) The merge is done with access table (i've tried with query but I obtain the same problem).
    3) The word freeze in the "waiting for DDE" step appened only on office sp3 pc's...

    .... boh!
    LVL 44

    Accepted Solution

    what happens if you make a template in word SP3 and try a merge with that one?

    Author Comment

    when I try to link word to access 97 db (every db!), It freezes with thie message "Waiting for Microsoft Access to Accept DDE Commands".  

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    This collection of functions covers all the normal rounding methods of just about any numeric value.
    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now