Check for Internet Connection (1 Viewer)

[AngelSpeaks]

Hi All! I am working on a database that will share images by email. I have the email part working but I was wondering if there was a way to check for an internet connection before emailing the image. The database will be on my laptop and I will be at various places doing a photobooth and sometimes the WiFi isn't all that great or not available (in which case, I will save the email requests for when I get home). Some research I've done had code snippets to ping Google or some other site that is expected to be up 24/7. Any ideas? Thanks

 

[Edgar_]

Yes, ping Google. You can add another tech giant just for better confirmation.

 

[MarkK]

Here's a Ping function...

Function Ping(ServerName As String) As Boolean
'   returns true if the server responds
'   to ping a url, remove the protcol, like https://,
'   eg: google.com
    Const PING_CMD As String = "%SystemRoot%\system32\ping.exe -n 1 -l 1 -w 500 "
    
    Ping = CreateObject("WScript.Shell").Run(PING_CMD & ServerName, 0, True) = 0
End Function

 

[theDBguy]

You can also check out this previous post.

Post in thread 'VBA code to check internet connection in Windows OS 64 bit, VBA MS Access 2019'

Jun 22, 2022

I have found reliable to just ping google in order to check if there's internet connection. I mean, it would be a disaster worldwide if google went down.

FWIW, here is my own very simple code to check for an internet connection which I have used successfully for over a decade.
However, MS recommend using INetworkListManager::GetConnectivity instead (not tested)

Option Compare Database
Option Explicit

#If VBA7 Then 'A2010 or later (32/64-bit)
    Private Declare PtrSafe Function InternetGetConnectedState Lib "wininet.dll" _
        (ByRef dwFlags As LongPtr, ByVal...

• isladogs

 

[AngelSpeaks]

Thanks everyone.

 

[sonic8]

I was wondering if there was a way to check for an internet connection before emailing the image.

Why?
A general internet connection is not really relevant for sending an email. - A ping to some website might work ok, even with the worst connection ever. Sending email might still fail nonetheless.
The really relevant bit is, whether your email server is available and can accept emails. The best (and only) way to find out is to try to send the email. Your code to send the email must be robust enough to fail gracefully, if something doesn't work.

 

[moke123]

Another option while away from home/office wifi is to use your phones hotspot.

 

[AngelSpeaks]

Why?
A general internet connection is not really relevant for sending an email. - A ping to some website might work ok, even with the worst connection ever. Sending email might still fail nonetheless.
The really relevant bit is, whether your email server is available and can accept emails. The best (and only) way to find out is to try to send the email. Your code to send the email must be robust enough to fail gracefully, if something doesn't work.

Because I wish to tell the individual at the photo booth that the email will arrive later because of no internet. The first thing they do is check their phones for the picture so they can laugh and brag.

 

[AngelSpeaks]

Another option while away from home/office wifi is to use your phones hotspot.

This option isn't recommended because of the volume of photos taken at the booth.

 

[sonic8]

Because I wish to tell the individual at the photo booth that the email will arrive later because of no internet.

You could do that all the same if sending the email fails.

 

[AngelSpeaks]

You could do that all the same if sending the email fails.

True but the error message would freak them out.

 

[sonic8]

True but the error message would freak them out.

"Fail gracefully" implies that you provide an error message to the user that does not freak anybody out.