I am working on an Access 2010 application.
I would like to click on a command button and open a Adobe PDF document.
The code for the On-Click event is:
Set shell = CreateObject("WScript.Shell") shell.Run """C:\Program Files (x86)\Adobe\Reader 11.0\Reader\acrord32.exe"" SourceFile"
When the Shell.Run line executes, Acrobat returns an error saying Access Denied.
I have RW access to the folder and can double-click on any PDF file there and open it successfully.
Can anyone explain why I can't open it from within my application?
Thanks in advance,