Waiting for Microsoft Access to Accept DDE Commands

Posted on 2006-05-24
Last Modified: 2008-01-09
Hello ~

Using a table in Access 2000 as the data source for a Word 2000 merge document, word opens and hangs w/ the following text at the bottom of the window: "waiting for microsoft access to accept DDE commands".

Can someone out there propose a remedy?  I've checked libraries and they all seem to be referenced.

Many Thanks
Question by:Chi Is Current
    LVL 77

    Assisted Solution

    Hi jacobbarnett,
    Check in Tools>Options>Advanced that Access is not set to ignore DDE requests.

    LVL 2

    Author Comment

    by:Chi Is Current
    Thank you Pete for your fast reply!

    IGNORE DDE Requests is UN-checked
    ENABLE DDE Refresh is checked
    LVL 2

    Author Comment

    by:Chi Is Current
    To check this out further, I opened a new Word document and attempted to establish a connection to my Access table from Word, using "Get Data Source".  Word hung w/ the message "Opening Microsoft Access" at the bottom of the window......  Access did not open??  Same result after a re-boot.
    LVL 22

    Accepted Solution

    Have you tried a compact and repair of your database?

    LVL 22

    Expert Comment

    Another thing you could try is to make a copy of your document. Then go to access and select your table. Go to OfficeLinks - Merge it with Microsoft Office Word and choose Link to existing document. Select the copy and see if it will merge it for you.
    LVL 44

    Assisted Solution

    by:Leigh Purvis
    What is it you're trying to connect to?
    A table?
    A query?

    (The former is a better idea - for speed).
    If you have functions or expressions then something could be preventing it from opening - or just slowing it down a *lot* :-)

    DDE is slower - but I dislike the OLEDB faff in Word 2003.  If they'd made it work better than it would have been ideal (ish).
    LVL 2

    Author Comment

    by:Chi Is Current
    I'm referencing a table.

    Well, was it the compact and repair or just the purity of my thoughts (unlikely), but now it's working just fine.

    I appreciate your ideas!  Thank you!

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    729 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

    19 Experts available now in Live!

    Get 1:1 Help Now