Open external files from access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jorge Novoa - 11 Sep 2007 03:43 GMT

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?

Signature

Regards.

Atte.
Jorge Novoa.

Reply to this Message

Dirk Goldgar - 11 Sep 2007 04:13 GMT

> Hello averyone,
>
[quoted text clipped - 14 lines]
>
> 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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

Jorge Novoa - 11 Sep 2007 15:58 GMT

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

Signature

Saludos.

Atte.
Jorge Novoa.

>> Hello averyone,
>>
[quoted text clipped - 27 lines]
> specifically with opening the files as hyperlinks, and the code at the
> above link would not trigger it.

Reply to this Message