hyperlink does not work

[NetworkTrade]

Access2003. Field in Table is defined as hyperlink.

In table, or Form based on table, to enter a value one right clicks with the
cursor in the empty field - select 'Edit Hyperlink' and then go find the file.

This inserts path string that appears correct.

And yet it does not work.

The jpg image file is definitely there. It is on a server on the network.
Using MyComputer one can open that image - so there is no security issue
blocking connectivity.

I have found that if I manually add the beginning part of the path syntax
then it will open ok. It appears the normal Edit Hyperlink method only is
resulting in part of the path.

Would welcome advice on this...thnks.

 

[Fred]

It might be helpful to clarify to yourself exactly what you want to have
happen / what you mean by "work".

When you double click on a .jpg file in "My COmputer" etc. , it opens it
using whatever image editing / viewing software which in your PC has been
designated as the default for that .jpg extension. If you double click on a
hyperlink in a field then mine tries to use a browser to look at that file.

I couldn't tell from your post whether or not you have the full path and
file name in the target portion of your hyperlink field.

If you are trying to show the picture in a form or report, then you normally
use other code to do that and use a text file(s) to store the path and file
name, i.e. you don't even use a hyperlink file.

Hope that helps a little.

Fred

 

[NetworkTrade]

after I have manually added the missing part of the path; then one can click
on the hyperlink and it launches photoeditor to view the image.

that is what I mean when I say it works. which it does

the problem is putting in the hyperlink into the field....to do so we really
need to rely on the Edit Hyperlink feature (or Insert Hyperlink) ....they
browse to the image using this Edit Hyperlink or Insert Hyperlink method and
are left with the impression that they have created the correct hyperlink.
But it doesn't work. The path is not complete....

Why does Edit Hyperlink or Insert Hyperlink result in just a partial path?

 

[Fred]

If you are talking about doing those programatically, you are in an area
where I don't know the answer. For me the using dialog box that you get
with a manual "edit hyperlink" selection loads the whole path and file name,
including across the network. It might be a clue to notice or double check:

- any pattern to where it truncates the path.
- any differences between your manually loaded path and the user's
navigation to that file and the path shown in the "edit hyperlink" dialog
box.

 

[NetworkTrade]

no programmatic approach involved. this is as vanilla as it gets

on my test PC just using a link to its own C: - everything works fine......

I can determine no explanation, nor a fix, on why only part of a path is
being stored when the image file is on the server......manual work-around of
adding in the rest of the path is a pain....