test for an ip connection

[jjohnson]

Does anyone know how to test for an active IP connection?
I need to connect to a remote database via IP, but I do not want to try to connect to the remote database if the PC does not have an active ip connection.

Thanks in advance.

 

[RV]

You could "ping" for the IP address of the PC.

RV

 

[ghudson]

Are you using a dial up connection?

I just found some Visual Basic code @ http://www.mvps.org/vbnet/index.html and it works in Access 97.

Search that site for the key words "active internet connection".

The code I tested came from the 'Determining an Active Internet Dialup Connection' example. You will find a bunch of examples if you need information for different types of connections and stuff when search for the key words I mentioned.

Sorry for not posting the code but it is against that sites rules to post their code.

HTH

 

[gmlwong]

...Ping?$?@??!...!

I just checked with a "network" guru friend of mine and he suggests to "PING" the address as well.

Restart your computer in MS-DOS mode and type <ping> followed by the address you are testing. If it is live, it will return packet information, proving it works.

i.e.: <ping 168.12.0.10>; I don't know if this example will "ping"...it's just for syntax. Don't type the greater/lesser signs...