ACC2000: How to Use a Secured Database in Word Mail Merge (208933)
The information in this article applies to:
- Microsoft Access 2000
- Microsoft Word 2000
This article was previously published under Q208933 Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access database (.mdb).
SUMMARY
This article describes how to use a secured Microsoft Access database in a
Microsoft Word for Windows mail merge. This article assumes you have already created or have access to a secured Access database.
To access a secured Microsoft Access database using Open Database Connectivity (ODBC) or Dynamic Data Exchange (DDE), you must
log on using a valid Microsoft Access account. Microsoft Word for Windows
does not open a merge document if you do not have "Read Data" permission on
the table or query that is specified as the data source.
REFERENCESFor more information about creating a secured database, click Microsoft Access Help on the Help menu, type security in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
For more information about passing the user name and password in a connection string, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type odbcconnectstr property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Minor | Last Reviewed: | 1/26/2005 |
---|
Keywords: | kbhowto kbinterop KB208933 |
---|
|