Create pdf encrypted files for every record of your table with a button

[zeeshanaslamdurrani]

Hi Guys ! I need your support urgently. I have a table in a database which has two fields id and employee names. There are 400 records in this table. I want to create a form with a button on it.



I want to automate creating 400 pdf files 1 for every record. All the pdf files should be password protected and this process should be automated with a button. Sample database file is attached herewith.

I hope the experts can help me here

Regards,
Zeeshan Durrani

[ItsMe]

Maybe with the full a version of Adobe Acrobat installed you could adjust security settings. Maybe a third party DLL file/Add In for a PDF printer? I have not seen anything intrinsic to Access that suggests security settings for PDF files are possible

[rpeare]

Like itsme, I haven't attempted to use the innate functions of access 2007+ to create a password protected file but I am sure you can do it with this:

http://www.lebans.com/reporttopdf.htm

I used it pretty extensively before access 2007 to export reports to PDF's