Security Password - Access to word Mailmerge

[Andrew Pla]

Dear Guru,

I have an issue which having read some previous threads may not be resolved simply. My database is password protected.

The password (presumably) is preventing the mailmerge from connecting the deata with the template. There is not even a password request shown. Is there any way that this can be overcome. There are a number of mailmerges but all are pulled from the same data query, can i unprotect this query only??

After convincing my boss that the dbase can easily run securely, your help will be very much appreciated.

Yours
Andrew - In sunny Hull, UK.

 

[Dennisk]

I've never come across this problem as when I mailmerge I only ever create CSV files which Word uses( I presume you are taking data staight out of Access).

 

[Andrew Pla]

I have a query setup which holds all the mailmerge data. I then have a link to the mailmerge templete which succesfully drops in the appropriate record on request from the user (when the data is not protected). However as it is 'word' requesting the data from access, it doesn't seem to aknowledge that the data is there at all.

Any ideas?