Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Using Access 97 for Word 2000 Mailmerge
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? -- Rich F |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Using Access 97 for Word 2000 Mailmerge
Hi ?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 :-) |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Using Access 97 for Word 2000 Mailmerge
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! -- Rich F "Cindy M -WordMVP-" wrote: Hi ?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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word Mailmerge with Access via DDE | Mailmerge | |||
Mailmerge Word 2000 Access 2000 | Mailmerge | |||
mail merge - Access 2000 and Word 2000 | Mailmerge | |||
Word 97 opening Access 2000 | Mailmerge | |||
MailMerge Word 2003 to Access 2000 query blank data | Mailmerge |