• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

using vb to password protect a file

I am looking to send an emailed statement from access that is password protected. I am using access to generate the statements into a pdf format. It looks like neither acrobat nor windows compressed file will allow me to assign a password to the attachment. Any suggestions?
1 Solution
Helen FeddemaCommented:
Where would the password operate?  Do you want to prevent unauthorized people from opening the attachment, or editing it, or what?  In any case, I think this is an Adobe issue, so you should probably cross-post this question in the Adobe zone.
jckingcpaAuthor Commented:
I would like to password protect the document. There is no need to edit. Just view. I am using the pdf option in MS Office to print them now. The user has to open each one and enter a password then send them to the user (this is a mundane process full of user error possibilities...they coule choose the wrong address).

Is there a way to use VB to protect a print from Access that requires a passord?
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Sure. I use this a lot:  ReportToPDF

Some of my client's also use PrimoPDF.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now