Open external files from access

[Jorge Novoa]

Hello averyone,

I'm developing an apllication with access 2003 in WXP professional, and I'm
storing documents in a folder... so they can be opened within access, I
actually store the complete path of the files in each record.. so I can call
the file from it's path and filename using the following code:
Application.FollowHyperlink Me.Path

In my PC that runs quite well!!!, it opens each .doc, or .pdf file.
BUT in some clients (with access 2003 and WXP pro.) when I open a .pdf file,
the file opens and inmediatelly closes. This doesn't happen with .doc files.
They remain open. I understand that Application.FollowHyperlink Me.Path
simply opens the file and nothing else. It always worked for me.

What can be happening? I've tried to reboot the computer, when I open the
file from the windows explorer, it opens fine... and so on...

Can anyone help me?

--

Regards.

Atte.
Jorge Novoa.

 

[Dirk Goldgar]

In

Hello averyone,

I'm developing an apllication with access 2003 in WXP professional,
and I'm storing documents in a folder... so they can be opened within
access, I actually store the complete path of the files in each
record.. so I can call the file from it's path and filename using the
following code: Application.FollowHyperlink Me.Path

In my PC that runs quite well!!!, it opens each .doc, or .pdf file.
BUT in some clients (with access 2003 and WXP pro.) when I open a
.pdf file, the file opens and inmediatelly closes. This doesn't
happen with .doc files. They remain open. I understand that
Application.FollowHyperlink Me.Path simply opens the file and nothing
else. It always worked for me.
What can be happening? I've tried to reboot the computer, when I open
the file from the windows explorer, it opens fine... and so on...

Can anyone help me?

As I recall, there was a bug in the early release of Adobe Reader 7.0
that caused this behavior with PDF files. See if the problem goes away
if you get these clients updated to the very latest version.

As an alternative, I think you can use the code at:

http://www.mvps.org/access/api/api0018.htm
API: Start an app with ShellExecute

to open the files. I'm not sure, but I *think* the problem was
specifically with opening the files as hyperlinks, and the code at the
above link would not trigger it.

 

[Jorge Novoa]

Thanx a lot!!!, I'll give it a try to both options.

--

Saludos.

Atte.
Jorge Novoa.