I am unable to get the password to persist in the mail merge using the Jet4
approach. I set it and say save password and then when I reload the data
source the password is gone. Any ideas?
thanks,
Winston

Which version of Word?

Which type of security are you using for your database? A database password
or workgroup security?

Also, does your database have more than one table/query?

Peter Jamieson

"Winston" wrote in message
...
I am unable to get the password to persist in the mail merge using the Jet4
approach. I set it and say save password and then when I reload the data
source the password is gone. Any ideas?
thanks,
Winston

Word 2003. Workgroup security. More than one table and query. thanks,
Winston

"Peter Jamieson" wrote:

Which version of Word?

Which type of security are you using for your database? A database password
or workgroup security?

Also, does your database have more than one table/query?

Peter Jamieson

"Winston" wrote in message
...
I am unable to get the password to persist in the mail merge using the Jet4
approach. I set it and say save password and then when I reload the data
source the password is gone. Any ideas?
thanks,
Winston

Assuming you are seeing the OLEDB data link dialog with tabs for "Provider",
"Connection", "Advanced" and "All", to make it work you have to specify
a. specify the user name and password on the Connection tab. To do that you
have to uncheck the "Blank Password" box
b. check the "Allow Saving Password" box on the Connection tab - you may be
able to check a box later in the dialogue, depending on how you are doing
things
c. on the "All" tab, specify the full name of the workgroup security
database (typically a .mdw file) in the "Jet OLEDB: System Database" item.

If you have simply selected the .mdb in Select Data Source and have been led
to this dialog, you will probably find that when you click OK, Word asks for
the table name, then pops up the data link dialog again - if so, fill in the
same values again, press OK, and you should be OK.

If you clicked the "New Source" button in Select Data Source, you will see a
further dialog box prompting for additional info. to go in a .odc file -
check the "save password option in there" and save the .odc file.

What happens when you use the connection again depends on whether you chose
to save the password and chose to select a table/query - broadly speaking,
if you did not save a password, you should find yourself back in the Data
Link dialog, with the database and workgroup security database names filled
in, user name filled in, but "blank password" checked. You then need to
uncheck the "blank password" box and specify the password. If you did not
choose a table, you should then be prompted to select a table. As above, you
may see this dialog twice.

Peter Jamieson

"Winston" wrote in message
...
Word 2003. Workgroup security. More than one table and query. thanks,
Winston

"Peter Jamieson" wrote:

Which version of Word?

Which type of security are you using for your database? A database
password
or workgroup security?

Also, does your database have more than one table/query?

Peter Jamieson

"Winston" wrote in message
...
I am unable to get the password to persist in the mail merge using the
Jet4
approach. I set it and say save password and then when I reload the
data
source the password is gone. Any ideas?
thanks,
Winston