Trapping A Clients ID on a Network

[Tom Olsen]

All,

I have a database (Access 2002) on a shared novel
network that people are using to refresh Excel models. I
would like to trap the ID of the machine when they
refresh their files to keep track of who and how often
the database is being used. The Clients are on Microsoft
2000 Operating System.

IN Advance... Thanks,

Tom Olsen

 

[Cheryl Fischer]

You should be able to get the computer name with the code at this link:

http://www.mvps.org/access/api/api0009.htm

Also, the login id from this link:

http://www.mvps.org/access/api/api0008.htm

hth,