Secured DB for a Word Mail Merge problem

[Tony_VBACoder]

I am having a problem getting my Word 2002 document to
Connect to my Secured Access DB for a Mail Merge. In my
Secured Access database, I have created a Query that has
all the fields that I need to merge with a Word Document,
however, when I am setting up my Word Document to be a
Mail Merge, I go through the Mail Merge Wizard
(Tools>Letters and Mailings>Mail Merge Wizard) and at Step
#3 under the "Use an existing list" I select "Browse".
Then when I select my secured MDB, I am prompted to log
into the database from the "Data Link Properties" dialog
box. In this dialog form, in #1, my MDB is listed and in
#2, I enter the User Name of the owner of the database,
that way I am certain of not having any permission
problems. I uncheck the "Blank Password" checkbox and
enter in this Owner's password. If I click either
the "Test Connection" button or "OK", I get the following
error "You do not have the neccessary permissions to
use...", which is the same error I get if I double-click
on my secured MDB file. To launch my secured DB, I use
the icon that the Security wizard created that has the
path to my MDB along with the MDW file to use.

What am I doing wrong? Don't I have to somehow specify
the MDW file when I am trying to make a connection to my
Secured Database within Word?

 

[Albert D. Kallal]

Hum, you could try my sample code here:

The above code complete ignores passwords and also security (don't confuses
the database password with ms-access security...they are two separate issues
here).

Anyway...you can try the sample here: (it has some sample data also).

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html


If it works...then you can read the instructions on how to use the merge
code in your application.