Re: DDE mailmerge between Word and Excel



The only thing I can think of is the MDAC (Microsoft Data Access Components)
version on the machine.

I don't know much about it, but I had a similar very perplexing problem that
required me to find and update the MDAC components. Search the Microsoft
site for them...


On 9/2/07 11:24 AM, in article
7AEDAF5C-5D36-4259-84D1-777E4ED61732@xxxxxxxxxxxxx, "jpccol"
<jpccol@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Until recently, I've been successfully merging my Word 2003 forms with my
Excel 2003 database using DDE. After loading Window XP updates on one
machine, the mailmerge is not working properly. The database does not stay
connected after file is closed. I can reopen and reconnect with the
database, and everything works fine, but when the file is closed and a new
document is later opened with the document template, no database is
connected, and I must go through the connection process again.

I think I've narrowed it down to a Windows Xp Pro (or Explorer 7) problem.
My Win 2k machine is not having the problem (with the same templates and
databases). My older XP Pro machine is having the problem, as is a new XP
Pro laptop I installed this week (all running the most recent Windows and
Explorer updates).

Any suggestions? Any new settings I'm overlooking?


--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <john@xxxxxxxxxxx>
Microsoft MVP, Word and Word for Macintosh. Business Analyst, Consultant
Technical Writer.
Sydney, Australia +61 (0) 4 1209 1410

.



Relevant Pages

  • Alert: Microsoft Security Bulletin MS04-003 - Buffer Overrun in MDAC Function Could Allow Code Execu
    ... Microsoft Security Bulletin MS04-003: ... * Microsoft Data Access Components 2.5 (included with Microsoft Windows ... Note The same update applies to all these versions of MDAC ...
    (NT-Bugtraq)
  • RE: Access 2000
    ... Microsoft Data ... "MDAC" and look for the version analysis software. ... Note that MDAC versions 2.5 and higher DO NOT have the Jet engine ... When accessing the database about half of the ...
    (microsoft.public.office.misc)
  • Re: are ado questions allowed here?
    ... Microsoft re MDAC ... This article describes the past, present, and future of Microsoft data ... * OLE DB (including SQL Server OLE DB Provider, ... will be available on the 64-bit Windows operating system. ...
    (comp.databases.ms-access)
  • [NT] Buffer Overrun in MDAC Function Could Allow Code Execution (MS04-003)
    ... Get your security news from a reliable source. ... vulnerability in a specific MDAC component, ... An attacker who successfully exploited this vulnerability could gain the ... updates available on the Microsoft Web site, ...
    (Securiteam)
  • Re: MDAC and SBS2003 SP1
    ... I checked what process is causing the DCOM error. ... Component Services tool and therefore I cannot change it's permissions. ... > Microsoft Management Console program, ... > installation issues with the Microsoft Data Access Components (MDAC). ...
    (microsoft.public.windows.server.sbs)