PC Review


Reply
Thread Tools Rate Thread

Systemdb works in Access2000 but some problem in Access2002

 
 
Sumesh
Guest
Posts: n/a
 
      26th Jun 2003
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you use an Access2002 mdb in Access2000? Chello Microsoft Access 2 11th Mar 2005 07:45 PM
sharing Access files between access2000 and access2002 Bill Microsoft Access 2 25th Dec 2003 07:00 PM
11 Oct 2003, Access2002(XP) , Whats new in Access2002 compared to Access2000 Sham Yemul Microsoft Access 1 11th Oct 2003 07:34 AM
Access2000 queries flakey in Access2002 Tom Conroy Microsoft Access Queries 0 10th Sep 2003 06:01 PM
Button created in Access2002 doesn't work in Access2000 Joe Strayer Microsoft Access Forms 0 7th Jul 2003 07:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:48 PM.