So far, the only way I have found to solve this problem is to save the Mail
merge Main Document as a Word 97-2003 .doc document (in compatibility mode).
That seems to work with both .mdb and .accdb format databases. I have
exactly the same experience as you if I save the Mail Merge Main document as
a .docx (or .docm)
I've done some searching and the first suggestion I came across said it
was
a security issue and I needed to set Access to trust the location the file
was saved in. Did that, still doesn't work. I then changed the settings
in
Word so it trusted the file location, still no luck.
Trusting the folder containing the .docx and/or the .mdb (or is it a .accdb
in this case?) in Word and/or in Access may also be necessary but it is not
sufficient. I do not think it is actually necessary unless the additional
security constraints Access imposes (when you do not trust the location)
prevent Word from "seeing" the objects it needs.
So, back to searching, next suggestion I found basically said it wasn't
going to work on a network drive.
It does here.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"mariacle" wrote in message
...
I have a database that, back in the days when we used Office XP I had no
problems with. Now that my office has migrated to Office 2007, I'm
banging
my head against the wall trying to solve what seems like a simple problem.
This problem, by the way, exists in both the old Office XP versions of the
files and my newly created Office 2007 versions.
I have a parameter query in Access that feeds a Word mail merge. When I
open the file in Word, I get the error message "Word could not
re-establish a
DDE connection to Microsoft Access to complete the current task."
I can then follow the options provided to re-connect to my query and run
the
query. But next time I open the file, same problem.
I've done some searching and the first suggestion I came across said it
was
a security issue and I needed to set Access to trust the location the file
was saved in. Did that, still doesn't work. I then changed the settings
in
Word so it trusted the file location, still no luck.
So, back to searching, next suggestion I found basically said it wasn't
going to work on a network drive. This is a problem, as both the merge
docs
and the access database will be used by multiple people, but for the sake
of
testing, I copy it to my local drive, add the new location to my trusted
locations in both applications, and try again. Almost the same thing
happens. This time Access is actually launched, my database is opened,
but
no message box to ask for my parameter.
How do I resolve this issue once and for all, so that my users will be
able
to run the merge as needed?