By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,918 Members | 1,557 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,918 IT Pros & Developers. It's quick & easy.

DDE Mail Merge issue

P: n/a
Hi,

We're running Office 2000 at our organization. We've been using an
Access database that is shared on the network; we have forms in the
database in which when we click on a button, data is retrieved using a
query and exported to a Mail Merge Word document. It has worked fine
for years. Recently we purchased a bunch of new computers on which we
installed Office 2000. On these new computers, when we open the Access
forms and click the button to generate the Word document, it gives us
an error message "Word could not re-establish a DDE connection to
Access". But everything works fine on the older machines. We haven't
changed any settings or upgraded to a newer version of Office. Does
anybody know what's causing this? The people who set this up for us are
no longer around so we have no clue what's giving us this problem for
only the newer machines.

Thanks,
Shal

May 23 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
From my experience when setting of new computers and copying/sharing Access
databases to the new machines, you have to also copy the My Data Sources.
This directory is found under the My Documents directory. Hope this helps.
"Shaldaman" <sh************@gmail.com> wrote in message
news:11**********************@j33g2000cwa.googlegr oups.com...
Hi,

We're running Office 2000 at our organization. We've been using an
Access database that is shared on the network; we have forms in the
database in which when we click on a button, data is retrieved using a
query and exported to a Mail Merge Word document. It has worked fine
for years. Recently we purchased a bunch of new computers on which we
installed Office 2000. On these new computers, when we open the Access
forms and click the button to generate the Word document, it gives us
an error message "Word could not re-establish a DDE connection to
Access". But everything works fine on the older machines. We haven't
changed any settings or upgraded to a newer version of Office. Does
anybody know what's causing this? The people who set this up for us are
no longer around so we have no clue what's giving us this problem for
only the newer machines.

Thanks,
Shal

May 24 '06 #2

P: n/a
"Jaeymeson" <Ja*******@hotmail.com> wrote
From my experience when setting of new
computers and copying/sharing Access
databases to the new machines, you have
to also copy the My Data Sources.
This directory is found under the My
Documents directory. Hope this helps.


Interesting, as there is no "My Data Sources" folder on my Windows XP
system. At best, that is a default folder and many users do not follow the
Microsoft line of thinking and use those default folders as Microsoft
expected. Most likely it is a local or personal convention patterned after
the naming convention used by Microsoft.

DDE is an obsolescent technology for inter-application communication and I
suspect the source of the problem is going to lie in some VBA code in the
application. I have not used DDE in years, probably not since the days of
DOS 3.1 and 16-bit Operating Systems, so can't even offer pointers on
specifics for you to look or search for. The functionality provided by DDE
was replaced by similar but improved functionality provided by the Component
Object Model (COM), which is itself now in the process of being superceded
by DotNet.

Larry Linson
Microsoft Access MVP
May 26 '06 #3

P: n/a
"Larry Linson" <bo*****@localhost.not> wrote in
news:1_sdg.6218$oa3.2470@trnddc08:
DDE is an obsolescent technology for inter-application
communication and I suspect the source of the problem is going to
lie in some VBA code in the application. I have not used DDE in
years, probably not since the days of DOS 3.1 and 16-bit Operating
Systems, so can't even offer pointers on specifics for you to look
or search for. The functionality provided by DDE was replaced by
similar but improved functionality provided by the Component
Object Model (COM), which is itself now in the process of being
superceded by DotNet.


Merge and the like works best with ODBC in my experience.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 26 '06 #4

P: n/a
DDE is one of the merge technologies supported by Word.
There isn't any particular VBA code: you just use the
appropriate Word merge method.

DDE merge underwent a resurgence with the introduction
of OLEDB/ADO. Using OLEDB, 'Queries' aren't visible
unless they are a 'view'. To restore the missing functionality,
you can't use the default merge method. Naturally,
the original method is the easiest to use.

(david)
"Larry Linson" <bo*****@localhost.not> wrote in message
news:1_sdg.6218$oa3.2470@trnddc08...
"Jaeymeson" <Ja*******@hotmail.com> wrote
From my experience when setting of new
computers and copying/sharing Access
databases to the new machines, you have
to also copy the My Data Sources.
This directory is found under the My
Documents directory. Hope this helps.


Interesting, as there is no "My Data Sources" folder on my Windows XP
system. At best, that is a default folder and many users do not follow the
Microsoft line of thinking and use those default folders as Microsoft
expected. Most likely it is a local or personal convention patterned after
the naming convention used by Microsoft.

DDE is an obsolescent technology for inter-application communication and I
suspect the source of the problem is going to lie in some VBA code in the
application. I have not used DDE in years, probably not since the days of
DOS 3.1 and 16-bit Operating Systems, so can't even offer pointers on
specifics for you to look or search for. The functionality provided by DDE
was replaced by similar but improved functionality provided by the
Component Object Model (COM), which is itself now in the process of being
superceded by DotNet.

Larry Linson
Microsoft Access MVP

May 29 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.