Member Avatar for rstringer

Hello All,

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,
Rich

  • 2 Contributors
  • 1 Reply
  • 357 Views
  • 7 Minutes Discussion Span
  • Latest Post Latest Post by Ancient Dragon
Member Avatar for Ancient Dragon

Maybe you need admin permissions to do that. Move the pdf file somewhere else such as c:\temp and see if the problem goes away.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.