Hyperlink in UNC format (revisited)

[John Waller]

I received the following advice to my original query (see original query
below):

"1) Start browsing from My Network Places rather than from My
Computer\C:\ "

After trying this, the result I get still provides an address relative to
the hard drive when working on the Win XP Pro machine which is both acting
as the intranet server and storing the MP3 files C:\ etc.

How can I insert a UNC format into the Hyperlink dialogue box on this
machine?

Regards

John Waller



ORIGINAL QUERY:
How can I insert a hyperlink in UNC format via the browse option in the
Insert Hyperlink dialogue box i.e. without actually typing the full UNC link
reference?

e.g. instead of c:\my music\song.mp3

I want the format in the hyperlink field to be \\server\c\my music\song.mp3

 

[John Nurick]

Hi John,

Well, it looks as if something is automatically translating the UNC path
of a "network place" into an ordinary Windows path if the UNC path is on
a local drive. I'd never run into this because I've never run Access on
a file server.

The work-rounds would appear to be:

1) An update query as I suggested before.

2) Work on the database from another workstation, so you're not creating
hyperlinks on on a local drive.

3) Build a custom "insert hyperlink" dialog that inserts a UNC path.

 

[John Waller]

Thanks for the reply, John.

Well, it looks as if something is automatically translating the UNC path
of a "network place" into an ordinary Windows path if the UNC path is on
a local drive.

That's what I suspected.

1) An update query as I suggested before.
2) Work on the database from another workstation, so you're not creating
hyperlinks on on a local drive.
3) Build a custom "insert hyperlink" dialog that inserts a UNC path.

Thanks. Good options to follow through.

Appreciate your advice.