I've searched the forums here and looked on Microsoft's site. I have a mail merge document in Word 2003 for which the data source is a query in a secure Access 2003 db. The security is handled using an .mdw file. When I do the merge and select "Use existing list" and try to use the secure Access db as the data source, I get the logon screen. However, when I enter my username and password, I get the error "Test Connection failed because of an error initializing provider. You do not have the necessary permissions to use the 'my db name' object." The path to my db is in between the quotes. When I go into the db normally, I have a shortcut set up on my desktop that opens the db and mdw file, which shows the login screen first. But when I am doing the mail merge this way, it is bypassing the mdw file and just doesn't let me in. I've seen a few posts and MS knowledgebase articles but none seem to show the problem I am having. Maybe I am doing something stupid?
Thanks for your help.
Alexis
Thanks for your help.
Alexis