PC Review
Forums
Newsgroups
Microsoft Access
Microsoft Access Security
Systemdb works in Access2000 but some problem in Access2002
Forums
Newsgroups
Microsoft Access
Microsoft Access Security
Systemdb works in Access2000 but some problem in Access2002
![]() |
Systemdb works in Access2000 but some problem in Access2002 |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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 |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

