Application.Hyperlink Problem (1 Viewer)

sherlocked · Apr 16, 2018

Experts,

I have the following code in two different databases:

Code:

Application.FollowHyperlink "\\S:\myfoldername", , True

In one of my databases, this works totally fine. In another, I get the following error message:

Run-time error 490 - Cannot Open The Specified File.

I have already verified that the path is correct in this second instance. I can navigate through manually and the shared folder location I'm looking for exists and the permissions to access it are correct.

Any idea as to why this same function would work in one database and not in another?

isladogs · Apr 16, 2018

Why have you created a duplicate thread?
Identical to this https://www.access-programmers.co.uk/forums/showthread.php?t=299301

sherlocked · Apr 16, 2018

Because I was not getting any responses and feared that I had posted it in the incorrect forum area.

isladogs · Apr 16, 2018

Give it a chance. Forum users do have other things to do...
You could also have mentioned it was a duplicate or asked mods to move it to another forum

arnelgp · Apr 17, 2018

You can try to covert the mapped drive

Code:

Function GetUNC(strMappedDrive As String) As String
    Dim objFso As FileSystemObject
    Set objFso = New FileSystemObject
    Dim strDrive As String
    Dim strShare As String
    'Separated the mapped letter from
    'any following sub-folders
    strDrive = objFso.GetDriveName(strMappedDrive)
    'find the UNC share name from the mapped letter
    strShare = objFso.Drives(strDrive).ShareName
    'The Replace function allows for sub-folders
    'of the mapped drive
    GetUNC = Replace(strMappedDrive, strDrive, strShare)
    Set objFso = Nothing 'Destroy the object
End Function

Then call it:

Application.FollowHyperlink GetUNC("S:\myfoldername")

Application.Hyperlink Problem (1 Viewer)

sherlocked

Registered User.

isladogs

MVP / VIP

sherlocked

Registered User.

isladogs

MVP / VIP

arnelgp

..forever waiting... waiting for jellybean!

Similar threads

Users who are viewing this thread