By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,940 Members | 1,328 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,940 IT Pros & Developers. It's quick & easy.

Gathering workstation data

P: n/a
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


Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.