Error 490 (Cannot Open the Specified File) - but link exists

[bsnalex]

On a form I have amended a button to point to a Sharepoint folder. It used to point to a network folder, but we're moving our folders to Sharepoint. I have tested it successfully on my PC. Browser opens, goes straight to the SharePoint folder specified. I tested this on an end-user's PC -- with them logged in (i.e. someone on the team who use the DB more than me) and received an error 490 - which is the error received when the file doesn't exist.

I can't understand why the button would not at least launch a browser. She has access to the correct folder on SharePoint. FWIW, here's the code:

Private Sub Command98_Click()

DoCmd.SetWarnings False
On Error GoTo ClickError

Dim TID As String
Dim FolderLoc As String

TID = Me!RGSCID
FolderLoc = "https://mycompany.sharepoint.com/sites/myteam/Shared%20Documents/Forms/AllItems.aspx?id=%2Fsites%2FNSHCS%2FShared%20Documents%2FTrainee%20Folders%2F" & TID

Application.FollowHyperlink FolderLoc
DoCmd.SetWarnings True
Exit Sub

ClickError:
If MsgBox("That folder does not exist.  Please check the folder location on the file and try again.  Error Code " & Err.Number & ": " & Err.Description, vbOKOnly, "Invalid Location") = vbOK Then
DoCmd.SetWarnings True
End If
Exit Sub

End Sub

Note I've obviously changed my company's sharepoint address to "mycompany" and my team's name to "myteam".

Any suggestions?

 

[bsnalex]

Update - after a few minutes the hyperlink works on the end-user's PC. I have no idea why. Interestingly enough, I tried it on two others' PC's and received error code 8: Cannot Download the Information you Requested.

Looking through some other articles, it may have to do with the "Work Offline" option in I.E. being enabled (despite Chrome being the default browser). We searched for this option but cannot find it; from what I now understand, the feature is disabled from I.E. 11 onwards. So I'm back where I started...

 

[bsnalex]

Update 2: Changed the code to point to Google. The users with error code 8 now successfully launch the link.

Am I missing something about SharePoint? Surely the users' browser should open no matter what, and let the SharePoint permissions determine whether the file can be accessed?

 

[The_Doc_Man]

The problem with permissions is that they are cumulative and often take the old "attaboy" attitude... a thousand "attaboys" are canceled by one "bullsnot" (or something like that). The technical way to say this is that permissions are MINIMIZED for network access. In essence, every step of each path is tested for permissions for everything that could be sensitive to permissions. And that includes group membership, general permissions, and specific FIREWALL permissions.

It may be off point, but I have personally run afoul of a case where I could not run SMTP because the "smart" (their name, not mine) router wasn't expecting MSACCESS.EXE to be the program sending an SMTP message through the CDO options.

So it could be explained by Google being in the list but IE or EDGE or whatever NOT being in the list. In fact, if you have Win10s in the mix, MS was shifting from IE to EDGE and I could see the network being set up for one but not the (deprecated) other. I don't think it is necessarily SharePoint.

Several of our users have specific experience with SharePoint and might yet respond to this. However, when I retired, our office was just then switching over to SharePoint and I never got to play with it so I'm approaching this from the Windows Security side of the picture.