Re: Cannot run a file from Access

"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in
news:u2zhBy7kHHA.3280@xxxxxxxxxxxxxxxxxxxx:

\DIR\File.pdf isn't a complete reference to a file. You need
either a drive letter, or a \\server\share in front of that.

Are you sure? Won't Windows resolve it relative to the current
directory?

In testing, I found that any valid path that is begun *not* with a \
is OK, dependent on the current directory (CurDir() returns this).

So, if the directory named "DIR" is in the current directory, then
this should work:

Shell("Dir\ExecutableFile.exe")

Of course, how an argument passed to an executable is handled will
depend on how that executable is written.

In the case of trying to open a data file, I'd use the ShellExecute
API, instead (using Dev's HandleFile wrapper,
http://www.mvps.org/access/api/api0018.htm).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: Cannot run a file from Access
    ... will this work in Access 97 - The computers this database runs on is ... either a drive letter, or a \\server\share in front of that. ... API, instead (using Dev's HandleFile wrapper, ...
    (microsoft.public.access.gettingstarted)
  • Re: Cannot run a file from Access
    ... either a drive letter, or a \\server\share in front of that. ... API, instead (using Dev's HandleFile wrapper, ... Any particular preference to that API over FollowHyperlink? ...
    (microsoft.public.access.gettingstarted)