Differences between Word 10 and Word 11 objects??

[Günter Brandstätter]

Hi all,

I wonder what I am doing wrong. I wrote a mailmerge-sequence in Word 2000,
which worked perfect.
Here ist my connection-string I use:
theDoc.MailMerge.OpenDataSource Name:=WhereIsDB _
, ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
Format:=0, Connection:= _
"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data
Source=" & WhereIsDB & ";Mode=Read;Extended Properties="""";Jet OLEDB:System
database="""";Jet OLEDB:Registry Path=""""" _
, SQLStatement:="SELECT * FROM `generierte Tabelle`" & strFilter,
SQLStatement1:="", _
SubType:=1 ' wdMergeSubTypeAccess

it works fine in Word 2000 but does not work anymore in Word 2003

I found that when I omit the "strFilter", it works again. Is there a
difference between W2000 and W2003?? Who can tell me what to do??

all answers appreciated
Günter

 

[Cindy M -WordMVP-]

Hi Günter,

The default connection method changed for Word 2002. It now uses OLE DB
instead of DDE as the default for Access. In your case, what you show below
should NEVER work for Word 2000...

I wonder what I am doing wrong. I wrote a mailmerge-sequence in Word 2000,
which worked perfect.
Here ist my connection-string I use:
theDoc.MailMerge.OpenDataSource Name:=WhereIsDB _
, ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
Format:=0, Connection:= _
"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data
Source=" & WhereIsDB & ";Mode=Read;Extended Properties="""";Jet OLEDB:System
database="""";Jet OLEDB:Registry Path=""""" _
, SQLStatement:="SELECT * FROM `generierte Tabelle`" & strFilter,
SQLStatement1:="", _
SubType:=1 ' wdMergeSubTypeAccess

it works fine in Word 2000 but does not work anymore in Word 2003

I found that when I omit the "strFilter", it works again. Is there a
difference between W2000 and W2003?? Who can tell me what to do??

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