Secure Hyperlink Fails

RichW · Nov 3, 2009

I have a table that contains hyperlinks; for example:

https://www.myboeingfleet.com:443/boldweb/documents/SB/MD11/SB-MD11-103-001-01--.PDF

If I cut-n-paste this hyperlink into a browser, it works. I'm taken to the
sign-on page and then to the pdf.

But, if I am in Access and click on the tables hyperlink, I am taken to the
sign-on page, but not to the pdf.

Help is always appreciated.

Thank you,
RichW

RichW · Nov 7, 2009

Problem Statement: Unable to access the content of an https site using
hyperlinks in MS Access, MS Excel and MS Word; for instance:

https://sitename.com/file.pdf

For the url shown above MS Access, MS Excel and MS Word will sent the user
to https://sitename.com

To get to the content (the file.pdf) the following code may be used:

Set myIE = CreateObject("InternetExplorer.Application")
myIE.Visible = True
myIE.Navigate = "<url string>"

In the first example, this code would be setup as:

Set myIE = CreateObject("InternetExplorer.Application")
myIE.Visible = True
myIE.Navigate = "https://sitename.com/file.pdf"

I use a table to store many urls; for this, I use the following code:

Set myIE = CreateObject("InternetExplorer.Application")
myIE.Visible = True
myIE.Navigate Me.tblName

RichW