Open external files from access


J

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.
 
Ad

Advertisements

D

Dirk Goldgar

In
Jorge Novoa said:
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.
 
Ad

Advertisements

J

Jorge Novoa

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

--

Saludos.

Atte.
Jorge Novoa.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top