Avatar of caandal
caandal
 asked on

password protect a pdf document in msaccess vba

Hi Experts

Has anyone found a way to password protect a pdf document in VBA.  Currently I am creating pdf's with the output to method but we now have a requirement for higher security.  

Any assistance will be much appreciated
Tx
Alan
Microsoft AccessProgramming

Avatar of undefined
Last Comment
Ian Wallace

8/22/2022 - Mon
Joe Howard

You will have to use third party pdf generation software, Microsoft doesn't provide an interface for password protecting.
caandal

ASKER
I thought as much - do you have any suggestions - the stuff that I have looked at is pretty expensive
Joe Howard

I use bullzip which is free, I'm putting the code together now.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
caandal

ASKER
Beaut tx
ASKER CERTIFIED SOLUTION
Joe Howard

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
caandal

ASKER
Hi Macroshadow

You are a star many thanks.  I have not tested it yet but looking though the code it all makes sense.  I am familiar with printer manipulation before printing as well.  This is a lot more simple than some of the other solutions that I looked at - and Bullzip is free - bonus

Thanks again
Joe Howard

You're welcome :) Let us now how it goes.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
caandal

ASKER
MacroShadow
It works flawlessly many thanks.  The client is exceedingly chuffed because the pdf software that they were using now is asking for a subscription so we have killed two birds with one stone.  The bonus is because theres are only 8 staff members using it they do not have to pay for the commercial license.
Cheers
Alan
Joe Howard

Good to hear.
Ian Wallace

Hi,

I know this is an old thread but thought it worth a shot.

When trying to run the code (Access 2016) it bows out at the line below with a message "Class Not Registered"

Set oBullzipPDF = CreateObject("Bullzip.PDFPrinterSettings")

Open in new window


Any help would be appreciated.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Joe Howard

Did you install the Bullzip pdf printer?
Ian Wallace

Hi Joe,

Yes I did. I just did the standard install.

Thanks,

Ian