We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

DDE Word 2000 sp3 -> Access 97

Medium Priority
371 Views
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??


Comment
Watch Question

Brian MulderFreelance
Top Expert 2006

Commented:
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
bruintje

Author

Commented:
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...
THE TEMPLATE IS MADE ON OFFICE SP1 PC.

.... boh!
Freelance
Top Expert 2006
Commented:
what happens if you make a template in word SP3 and try a merge with that one?

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
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".  
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.