Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2004

Tip: Looking for answers? Try searching our database.

Word 2003 & Access 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ronil Patel - 15 Apr 2004 01:16 GMT
I am trying to use the Data Link Wizard and it does not ask me for any workgroup file. I have a Databse on the server which requires a .mdw workgroup file to have permission. How can I make this connection to use Mail Merge?
Peter Jamieson - 15 Apr 2004 14:15 GMT
. However,
As far as I know you must do one of the following:
a. Create a Microsoft Data Link (.udl) file.  (e.g. create an empty file
with a .udl extension, then double-click it to edit it) and specify the
Workgroup in there - once you have specified the Jet data provider, you need
to add any required login info and go to the last ("All") tab of the dialog
and specify the full path name of your Workgroup file in Jet OLEDB:System
Database
b. As (a), but create the file using the similar facility that appears when
you click the "New Source" button in the Select Data Source dialog in Word.
In this case, you end up with a .odc file instead of a .udl file.
c. use ODBC instead of OLEDB, and set up a DSN that specifies the workgroup
file.

(Usually, when you select the .mdb in Select Data Source, if Word cannot
open the .mdb it pops up the data link dialog. Although it looks as if you
ought to be able to provide the same info. in there as you do in (a) and (b)
above, it does not actually seem to work, which is why you need to do either
(a) or (b).   But if you then cancel that dialog, Word tries to open using
ODBC, and if that does not work, it tries DDE, which can be confusing to say
the least.)

Signature

Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> I am trying to use the Data Link Wizard and it does not ask me for any workgroup file. I have a Databse on the server which requires a .mdw
workgroup file to have permission. How can I make this connection to use
Mail Merge?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.