Mailmerge and security

[garywood84]

I am using Access 2003 and have secured my database, so that it now consists of an .mdb and an .mdw file. The .mdb is opened using the security settings in .mdw using a shortcut.

I want to set up a mail merge into Word 2003, but whenever I try selecting my database as the source of the data I want to merge, it won't let me log in.

Can anyone advise me how I can get this to work correctly?

Thanks,

Gary

 

[stepdown]

I seem to be having the same problem, I have read the article on connecting to a secured database (http://support.microsoft.com/default.aspx?scid=kb;en-us;208933) and followed the instructions, but still get the following error message when I try to connect.

"Test connection failed because of an error in initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user"

I have a feeling that this is because I am using a custom .mdw file for security. When I open the database I use a shortcut which looks like this...

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /user Developer /wrkgrp "\\fileserver\x\Workgroup.mdw" "\\fileserver\Database\Database.mdb"

And then enter the Developer password when it prompts me. I guess I need to somehow point Word to the correct .mdw file, but this isn't mentioned in the MS article and I couldn't find any options just by looking around the mail merge boxes. I tried adding the shortcut commands into Word's database locator, but it said that they were not valid locations.

Ideally I would want to keep the security as it is, but it looks like this may not be an option. As always any help would be greatly appreciated.

Thanks
Step


Edit - I guess this probably should really be in the Word section, but as I found an existing thread, I thought better to post in that.

 

[Dennisk]

there is another way of doing this and that is export the data to a csv file and mailmerge that instead of a connection to a secured db.

 

[stepdown]

Thanks for the pointer, I'll try that and come back if it works or not