Determining Internet connection

[CAS]

I'm trying to create coding for a button that will allow the user, when the button is clicked, to access a company directory. If the user is working either from the office or on a laptop with an Internet connection, I'd like to have Access open the web page into a form.

If, however, the user is on a laptop without an Internet connection, or the connection is otherwise disrupted, I'd like to have Access display a pre-saved form (which will contain a directory, but not as up-to-date as the online version).

Is there a way to have Access test for the existence of an Internet connection, or trap an error if trying to hyperlink to a web page that can't be accessed?

Thanks!

 

[shadow9449]

Is there a way to have Access test for the existence of an Internet connection, or trap an error if trying to hyperlink to a web page that can't be accessed?

Thanks!

I know that this question is many years old but I was looking for the same thing so I thought I'd share the answer I found in case it helps someone. I tried this method and it's easy to implement. Although it's given for VB, Access will use it just as well.

http://www.a1vbcode.com/vbtip-119.asp

Edited to add that I may have jumped the gun here. I unplugged my modem and it said I was connected to the internet still. It didn't know I was disconnected until I unplugged my router. If you use it, be aware of this limitation.

SHADOW