Question Can't sign PDFs created by Access 2010

tthuene

New member
Local time
Today, 06:34
Joined
Feb 22, 2012
Messages
8
I have two database front ends, one in Access 2003 on XP and another on Access 2010 on windows 7.
I often create PDF files using Access 2003 (through PDF Create VBA Object Model), open the PDF File in Adobe 9 (or later), and provide a hyperlink in the database.
I can do the same thing in Access 2010.
However, if I open the pdf file through the hyperlink in Access 2003 (user admin), I can sign the PDF File electronically. This would require me to save (overwrite) the file in the directory. This works fine in Access 2003.
If I try this in Access 2010 (also user Admin), it doesn't work. The PDF File opens in Adobe 9, and I can sign it. However, if I want to save it it tells me that I don't have the rights to do so. If I opened the file from the Windows system (now the user is me), I can sign the file electronically and overwrite the previous file.
I suspect that the user "Admin" in 2010 is different from that in 2003. How can I make them the same, in particular how can i make them that of 2003?
Thanks, Thomas
 
There are different flavours of PDF's I can across one that you could not even copy and paste.

If there has been a change in Acess 2010 then look on the web for a free pdf creator, sorry I can't remember what I used and you can create editable versions of the PDF.

I did see somewhere that a Postscript printer can produce PDF formats but I never tried doing so.

Simon
 
I originally uses PDFCreator as I was coming from 2003. Same problem. The issue are the rights granted to the user Admin in 2010.
 
I originally uses PDFCreator as I was coming from 2003. Same problem. The issue are the rights granted to the user Admin in 2010.

Someone posted that he/she had created a DB in 2010 and was able to create a PDF and then sign it the way it was supposed to be. I had no reasons to doubt that (the post seems lost for some reason). But it made me dig deeper.
It turns out when Access in OUR (i.e., of my employer) opens a PDF in Adobe Acrobat 9 this is executed in a service that is usually reserved for firewall and similar stuff. Don't ask me why, i am not a systems expert.

I created a shell script that opens the PDF. I call it from Access and everything is fine.
 

Users who are viewing this thread

Back
Top Bottom