G
Guest
Password Protection for E-mailed Access Report
Sorry this is a bit long winded but here goes - we have a very simple Access
2002 DB of 60 – 100 client records. It’s updated weekly and a report is then
sent to a distribution list. In the past it was printed and faxed. As all on
the list have e-mail I set up a macro to e-mail the .mdb to an Outook
Distribution List. It works wonderfully and is much easier and faster.
However - a couple of weeks ago one of the users complained saying we must
password protect the data. Our Exchange Server is not yet set up to use
certificates and Ditital IDs so I worked out the only way I can think of to
p/w protect the file. The data is exported as an RTF. Once the user is in
Outlook she opens the attachment and runs a macro in Word which :-
Saves the RTF as a DOC file (uses the same name each time)
Saves the DOC file with password protection
However the user reports that often it seems to link to the previous weeks
data unless she deletes the attached file and opens the TEMP internet files
folder, finds the correct week and attaches that.
Can anyone think of an easier and more foolproof way of doing this – is
there something in Access I have missed?
Thanks for any help or advice - Dika
Sorry this is a bit long winded but here goes - we have a very simple Access
2002 DB of 60 – 100 client records. It’s updated weekly and a report is then
sent to a distribution list. In the past it was printed and faxed. As all on
the list have e-mail I set up a macro to e-mail the .mdb to an Outook
Distribution List. It works wonderfully and is much easier and faster.
However - a couple of weeks ago one of the users complained saying we must
password protect the data. Our Exchange Server is not yet set up to use
certificates and Ditital IDs so I worked out the only way I can think of to
p/w protect the file. The data is exported as an RTF. Once the user is in
Outlook she opens the attachment and runs a macro in Word which :-
Saves the RTF as a DOC file (uses the same name each time)
Saves the DOC file with password protection
However the user reports that often it seems to link to the previous weeks
data unless she deletes the attached file and opens the TEMP internet files
folder, finds the correct week and attaches that.
Can anyone think of an easier and more foolproof way of doing this – is
there something in Access I have missed?
Thanks for any help or advice - Dika