Secured DB for a Word Mail Merge problem

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
(ToolsLetters and MailingsMail 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?

Hum, you could try my sample code he

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 he (it has some sample data also).

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


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


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

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