DDE Word 2000 sp3 -> Access 97

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??


pzilioliAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bruintjeCommented:
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
pzilioliAuthor 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!
bruintjeCommented:
what happens if you make a template in word SP3 and try a merge with that one?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pzilioliAuthor 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".  
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.