Using Access 97 for Word 2000 Mailmerge

[Rich F]

There are many threads that skirt arond my issue, but I wasn't able to find
an answer that appeared to circumvent my issue:

We are using Word 2000 and Access 97 on our machines at work. Have a Word
document that mailmerges with an Access query that worked when all MS Office
apps were Office 97. When I try to open the document now (with Access 8976
and Word 2000), I get the messge that Word could not re-establish a DDE
connection to Microsoft Access to complete the current task. I have attempte
to "find the data source" numerous times, but DDE is not an option when I'm
trying to reconnect (and that seems to be key to many other posters'
problems), so I've been unsuccessful at re-attacehing the Access query. I
checked "Confirm conversion at Open," but still cannot find DDE as an option
when attempting to find the data source. The Word file works fine on my
machine at home running Access 2003 and Word 2003.

Any guidance, o, sage ones?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?UmljaCBG?=,

DDE is version-specific; you can't use DDE to connect Word 2000 to Access 97.

But you should be able to use ODBC, as long as the query in question is not a
parameter query, nor use user-defined functions (both require the Access UI in
order to execute).

We are using Word 2000 and Access 97 on our machines at work. Have a Word
document that mailmerges with an Access query that worked when all MS Office
apps were Office 97. When I try to open the document now (with Access 8976
and Word 2000), I get the messge that Word could not re-establish a DDE
connection to Microsoft Access to complete the current task. I have attempte
to "find the data source" numerous times, but DDE is not an option when I'm
trying to reconnect (and that seems to be key to many other posters'
problems), so I've been unsuccessful at re-attacehing the Access query. I
checked "Confirm conversion at Open," but still cannot find DDE as an option
when attempting to find the data source. The Word file works fine on my
machine at home running Access 2003 and Word 2003.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Rich F]

Cindy,

That's sort of what I thought, but I was hoping there was a work around
someone might have known about. Guess I'll just have to push for us to
upgrade to Access 2000, so it all works.

Thanks for the help and have a great new year!