This is a discussion on BDD with Word2000 - basic.visual ; Hi all I have write on my machine (XP and Word 2002) this code to connect with Word : With ActiveDocument.MailMerge Dim strConnection As String .MainDocumentType = wdFormLetters strConnection = "DSN=MYDSN;" _ & "DBQ=C:\secteurs\mybase.mdb;" _ & "FIL=redISAM," .OpenDataSource Name:="C:\secteurs\mabase.mdb", _ ...
Hi all
I have write on my machine (XP and Word 2002) this code to connect with
Word :
With ActiveDocument.MailMerge
Dim strConnection As String
.MainDocumentType = wdFormLetters
strConnection = "DSN=MYDSN;" _
& "DBQ=C:\secteurs\mybase.mdb;" _
& "FIL=redISAM,"
.OpenDataSource Name:="C:\secteurs\mabase.mdb", _
Connection:=strConnection, _
SQLStatement:="SELECT * FROM `TABLE`"
End With
this code run fine on my computer, but after install on other computer
with W2K et Word 2000, nothing.
Any help appreciate.