password protect a pdf document in msaccess vba

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

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

I use bullzip which is free, I'm putting the code together now.

Beaut tx

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

You're welcome :) Let us now how it goes.

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

Good to hear.

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")

Select allOpen in new window

Any help would be appreciated.

Did you install the Bullzip pdf printer?

Hi Joe,

Yes I did. I just did the standard install.

Thanks,

Ian