automate mail merge in a secured db

[Gino Ferreri]

I have an Access 2000 database that is secured. I want to
create a mail
merge document in Word that uses a table in my front-end
database.

Creating the document in a non-secured (ie leave the
wokgroup) db is no
problem. When I do it on the secured db (ie join the
workgroup) Word
prompts me for a password, which makes sense but I do not
want to prompt user to enter login information again. I've
been using OLE in VBA to program it.

Does anyone know how to assign the MailMerge object in
Word with a
datasource in my db so that it doesnt ask for the password?

Please let me know via email as well.

Thank you

G. Ferreri

 

[Albert D. Kallal]

Try my sample code. It works well with secured database.

in addition, you can word merge ANY data form you have with one line of
code.

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