If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Word Mail merge with Access on Vista
I'm trying to do a Word mail merge with Access on Vista, but since we added a
password security to Access, it doesn't work. Non-Vista users are not having this problem. We get the error that says it's password protected, but doesn't direct us to where to enter it, any help? |
#2
|
|||
|
|||
Word Mail merge with Access on Vista
Ths may not be a Vista/non-Vista issue (i.e. you may see it simply
because your Vista systems happen to be set up one way and other systems another way). But... ....before I have another look at this, can you say a. what the versions of Word and Access are b. whether you are using 32-bit Vista or 64-bit Vista (this may not be relevant but right now I can only look at the 32-bit version and there can be differences between the two) c. which connection methods your Vista/non-Vista systems are set up to use (if the users never see questions relating to the connection method, then the defaults will be DDE for Word 2000 and earlier, and OLEDB for Word XP and later) FWIW When you use a database password, I believe you will need to do one of the following: a. connect using DDE, in which case Word should start Access (if it is not already running) and request it to open the database (if it is not already open). If the database is not already open, Access should present a password prompt, which may appear behind the Word window (i.e. the user might need to use Alt-tab or some such to see it. To do this with Word XP or later you have to set up Word so that it will prompt for the connection types. If you are using Word 2007 and Access 2007, the additional dialog box that then appears will not show the DDE option if the database is an Access 2007 .accdb format database - in that case you have to check the "Show all" box to see the DDE option. b. connect using OLEDB /and/ a .odc file which specifies the password - I think. Peter Jamieson http://tips.pjmsn.me.uk HeleneJ wrote: I'm trying to do a Word mail merge with Access on Vista, but since we added a password security to Access, it doesn't work. Non-Vista users are not having this problem. We get the error that says it's password protected, but doesn't direct us to where to enter it, any help? |
Thread Tools | |
Display Modes | |
|
|