Data Type Hyperlink - Problems!

[Guest]

Hello to all!

I have created a database with the data type Hyperlink. The table stores
hyperlinks to pdf files on the network. The hyperlinks are to a mapped drive
for example w:\well files\pdf files\test.pdf. The hyperlinks are not
working. I have 100 records. 5 hyperlinks are working, the rest are not.
They are pointing to the same place. I have deleted the hyperlinks and
reinserted them. I do not know what else to do to troubleshoot. Any ideas?
Thank you!

 

[pietlinden]

what if you use some code at VBNet to convert the mapped drive to a UNC
path and then store that? Personally, I'd store the UNC path in a text
field and then format stuff on the form as a hyperlink.

http://vbnet.mvps.org/code/network/uncfrommappeddrive.htm