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 / June 2007

Tip: Looking for answers? Try searching our database.

Mail merge using a secure database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DavidF - 20 Jun 2007 22:19 GMT
I have a user that is trying to do a mail merge using a secured access
database and when the database is accessed, using the right password and
correct priviledges, it opens with gibberish.  Is there a special way for
mailmerge to access a secured database.  Using office 2007 and access 2003.
Peter Jamieson - 21 Jun 2007 00:25 GMT
How exactly are you doing it at the moment?

As far as I know, you have to do one of the following:
a. get Word to prompt for the connection method, choose DDE, and respond
correctly to the prompts displayed when Access tries to open the database
(unless the database is already open)
b. get Word to prompt for the connection method, choose ODBC, but after
modifying the ODBC DSN so that it specifies the workgroup database, username
and password (in fact I am not sure this can work)
c. use MS Query with a suitable ODBC DSN
d. use a file DSN
e. use an Access .odc file with the necessary workgroup file, username and
password
f. (may) use a .udl file with the necessary workgroup file, username and
password.

(I can't easily experiment on this here unfortunately).

Peter Jamieson
>I have a user that is trying to do a mail merge using a secured access
> database and when the database is accessed, using the right password and
> correct priviledges, it opens with gibberish.  Is there a special way for
> mailmerge to access a secured database.  Using office 2007 and access
> 2003.
 
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.