Secure database and merging with Word files



How do you merge a query from a user level secured Access 2003 database with
a Word merge file.

We have a database that has been secured with user level security and is
split into a front and back end. Prior to securing the database, there were
a number of Word files that were merged with data from the unsecured
database. The merge was performed by opening a query and selecting "Merge
it with Microsoft Word."

Now the merge won't work even after typing in the user name and password.
The user is a member of the Admins group.

Thanks in advance for help.

Tom van Stiphout

On Wed, 17 Jun 2009 17:15:14 -0400, "Nomy" <[email protected]>

The only way I can think of that could possibly yield good results is
to do the mailmerge more programmatically. Then when you specify a
datasource, use an ODBC connection string that can include the
username/password. See for details.

Or have the app export a CSV file that Word can pick up and work with.

Microsoft Access MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question