Systemdb works in Access2000 but some problem in Access2002

S

Sumesh

ConnectStr = "DSN=MS Access Database;" _
& "DBQ=c:\temp\xyz.mde;" _
& "SYSTEMDB=c:\temp\abc.mdw;" _
& "UID=vvv;PWD=vvv;"

With ObjWord.ActiveDocument.MailMerge
.MainDocumentType = 0
.OpenDataSource _
Name:= c:\temp\xyz.mde, _
LinkToSource:=True, AddToRecentFiles:=False, _
Connection:= ConnectStr, _
SQLStatement:=ssql

I am using this piece of code in mail merge with secured
MSAccess2000 database and Word 2000. It works fine.

But when I use the same code for Office XP (MSAccess2002
and Word2002) and when I execute mail merge the "Data Link
Property " dialog window appears but by just pressing
cancel button the mail merge works fine.

I don't want to see the "Data Link Property" dialog i.e.,
there shouldn't be any user intervention while mail merge
takes place.

Appreciate your valuable time.

Thanks and Regards
Sumesh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automated mail merge problem 7
SQLStatement exceed 255 characters in word mail merge using ms accessdatabase 4
security and automation 0
Use Merge Field in Email "To" field 2
Mail Merge Problem 5
Mail Merge With Seperate Source and Header files 4
doc.Mailmerge.datasource.querystring=strSQL; Command Failed: Run-Time error 4198 2
Problem with mail merge 2

Top