Hyperlink to Shared Folder

[Vernon]

I have created a table with a hyperlink field. The
hyperlink is used to open files stored in a "shared"
folder on the network server. The database is stored in
the same shared folder.
Currently I specify the hyperlink by using the UNC name
(\\server\share\filename). However, when the database is
distributed to other locations/servers with the same
setup, I have to manually change the UNC reference in the
hyperlink field's default value.
I would like to be able to specify a hyperlink that
points to the folder containing the database, but I'm not
sure how . . . or if it is even possible. Web page
hyperlinks allow you to use "..\" to point to the root
folder without specifying the actual folder name. Is
there an equivalent method for MS Access?

Regards,

Vernon

 

[Vernon]

OK... I have figured out that I can set the HYPERLINK
BASE in the database properties window. This allows me
to simply set the hyperlink as the filename. However,
when I type in the filename in the hyperlink field, the
actual hyperlink defaults to "http:\\filename". Is there
a way to get Access to accept whatever I type in as the
hyperlink?

 

[John Nurick]

Hi Vernon,

I'm not sure about this, but here are two things to try.

First, try using a URL protocol specifier in the HyperlinkBase, not
just a UNC path, e.g.
file://SERVER/SHARE/

Second, try using
filename.ext#filename.ext#
in the hyperlink field instead of just
filename.ext
and see if this overrides the default behaviour (see the VBA help topic
for the HyperlinkPart() for an explanatin of this).