Differences between Word 10 and Word 11 objects??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

G?nter Brandst?tter - 05 Oct 2004 07:13 GMT

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

Reply to this Message

Cindy M -WordMVP- - 31 Oct 2004 11:05 GMT

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.
[quoted text clipped - 15 lines]
> 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 :-)

Reply to this Message