Identify computer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an application which will be distributed to several computers
networked to a VPN. We would like all computers to be able to download data
from the VPN to local tables. We want ONLY ONE of those to be able to upload
back to the VPN.

How can I use VBA to determine which computer an application is running on?
An IP address or the computer "name" might be sufficient.

Or please suggest some other (secure) way to be able to identify one
installed version of the program as being special?
 
Hi,

Sheryl schreibselte:
I have an application which will be distributed to several computers
networked to a VPN. We would like all computers to be able to
download data from the VPN to local tables. We want ONLY ONE of
those to be able to upload back to the VPN.

How can I use VBA to determine which computer an application is
running on? An IP address or the computer "name" might be sufficient.

Or please suggest some other (secure) way to be able to identify one
installed version of the program as being special?
Click to expand...

You could use the MAC-Adress
see at:
http://www.scottandmichelle.net/scott/code/code-063.html

Acki
 
Sheryl -

Google the GetUserName() function. It has the functionality you seek.
Works great!
 
Back
Top