Encryption on Reports

[Freshman]

Hi all,

Need some ideas.
I'm sending payslips to Staff members of our Clients but they would like for it to have encryption on it.
At the moment I'm sending it in Snapshot format.
I can convert the Report to pdf as well and send that.
But I don't know how to add encryption.

I'm also thinking of instead of emailing the payslips making them availible on the web but then I would have to build a site with login controls for each Staff members.

Any ideas on sending stuff encrypted would be nice.

Thanks
Pierre

 

[CJ_London]

Do you mean encrypt or password protect?

If they were sent in Excel or word, you can use vba to open the file, password protect, then save. I presume you can do the same with pdf's but you will probably need to purchase the relevant Adobe product to gain access to the

You will also need to consider how you transmit the password - not much point including it in the email, so presumable you will need to add a field to the relevant table to store individual passwords and let everyone know in advance what it is.

This thread will give you an idea of what is involved

http://www.access-programmers.co.uk/forums/showthread.php?t=227759

 

[Freshman]

Hi London,

Thanks for the clarification yes - it is password protection I really need.

PDF would suit me better than Excel since the format for the payslip is already half way there.

I remebered that I had a piece of code that coverts a report to pdf and when I looked at the parameters I noticed that you could include password options.

So my idea now is one of two (or probably both options):

1. Store a password for each Staff member in a table.
2. Step through the base and convert each payslip report to pdf using the relative password
3. eMail the protected pdf as an atachment to each Staff's email
4. Upload the protected pdf to our website while combining the file name to the Staff number so each Staff will have a unique URL where he can download the payslip and use his password to open it.

I like option 4 over option 3 in that Send Object doesn't cater for attatchments so I have to use the Outlook Object. The bummer is that I cannot control what eMail Client each Staff is using and cannot force all to use Outlook.

Thanks for your input
Pierre