how to open a file use its full directory in access 2003

[cyndi]

i know how to active an exe file by Shell() function, but if i want to open
the file has the directory like "c:\my document\001.jpg ", which function
should i use, i try shell() too, but it does not work, and tell me the
argument is wrong.

would you please tell me how to open the file excepte the exe file, thanks

any help wil be appreciate

 

[Allen Browne]

Shell works for an executable.

To start a document with whatever program program is registered to handle
it, use FollowHyperlink.

If you prefer an API call, use ShellExecute:
http://www.mvps.org/access/api/api0018.htm

To get FollowHyperlink to work, you may need to Replace() special
characters, e.g. replace # with %23