Using PING in Access

[SteveC24]

Hello all,

I believe this is an actual tough one, rather than just something I am being thick about...

I would like to use the results of a ping in Access. For example, I ping 192.168.2.100, if it is available, and therefore replying successfully, I would like Access to report the address as active, otherwise, the ping would time out, and Access should report it as inactive.

I have found an article on the web about it (HERE) but it is all about using it in VB6 - but I have no idea how to convert this into VBA.

Does anyone have any ideas? Or any other way to determine if a PC on the network is active or not?

Thank you very much indeed!

 

[FoFa]

You can create a PING command that dumps the output to a file, then turn around and read that file in Access.
You can run the PING command via SHELL.
You can see on the attached (with relevant data erased for security reasons) that I created the ping to a file, and then using the DOS type command displaied the file.