PC Review Forums Newsgroups Microsoft Access Microsoft Access Security Systemdb works in Access2000 but some problem in Access2002

Reply

Systemdb works in Access2000 but some problem in Access2002

 
Thread Tools Rate Thread
Old 26-06-2003, 03:45 PM   #1
Sumesh
Guest
 
Posts: n/a
Default Systemdb works in Access2000 but some problem in Access2002


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
  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off