"Paul Wagstaff" <wa***@blueyonder.co.uk> wrote in message news:<su*****************@nurse.blueyonder.net>...
Hi there folks,
Within Access 97,
Can anyone tell me the proper way to 'ping' a workstation on a NT 4 network
and/or gather data such as the IP adress. Currently I have code and use
SendKeys, which I know is rubbish...I'd also be grateful if such things as
the FAP of the workstion could be ascetained. In short, what I'm asking is
what is the best way to get a bunch of data about remote workstations?
TIA
Paul
Paul,
have a look at Randy Birch's website...
http://vbnet.mvps.org/
You won't be sorry. He has mad amounts of VB stuff that does this.
There's code to get the IP address, MAC address of devices on the
network. You can also get a list of servers/workstations on the
network through code. Not sure what I did wrong when I tried to
implement this, but I managed to crash the server once when trying to
run something that did the following:
1. get a list of hostnames on the network.
2. specify if they're workstations or servers.
3. get the IP address of each computer.
4. get the MAC address of each network card on each workstation.
worked fine if I ran the functions individually, but if I did them in
sequence and tried to write the whole thing to a table using VB, it
died.
you might want to check the VB newsgroup on this... the only thing you
can't really do with Acces that you can do easily with VB is to create
control arrays. So you'll have to modify the code from Randy's site
to work with Access.
HTH a little,
Pieter