Hyperlink field won't work with UNC address

[SunGodly]

Gurus -
I have a hyperlink field in a form (using Access 2002) that does not appear to be working correctly. Beside the field, I have programmed a button that allows a user to browse to a document, then through code the address is converted from standard (C:\folder\filename) to UNC (\\server\share\filename). When I click on the UNC address, the document does not open. However, if the address is in standard format, it opens just fine. If anyone has any suggestions or has run into the same problem, I would love to hear about it.

Thanks!

 

[Isadore]

Sun, is your mdb on the \\server drive? If so you might try:

Dim strPath As String
strPath = CurrentProject.Path 'set default path to mdb

Just an idea.

 

[Isadore]

Ms. F. Prairie shared this with me some time ago - If the path is correct, not sure why it would not work.

 

[SunGodly]

Thanks for the reply. Actually, the link should be flexible enough to put to a different server (other than the one the mdb is on). I could program a click event through VBA to open the hyperlink but that really defeats the purpose of a hyperlink field type - Access should be able to handle it without code (in my humble opinion!). Any other suggestions?

Thanks again!