Need to mailmerge from secured database

[SarahG]

Hi, I have an access database with security enabled so that the Admin user can't open it.
However, I can't point Word's mailmerge at the database now. Is there a setting in word that I can put in a userid/password, or set a connection string to the database so that Word can access the database.

 

[PaulBricker]

Depending on how you are running the mailmerge, like from a module, you can look at this page. There are examples of connect strings to secured and unsecured databases.

http://www.connectionstrings.com/?carrier=access2007

It may be all you need to accomplish what you are doing.

Paul