User ID field

  • Thread starter Thread starter JayTee
  • Start date Start date
J

JayTee

Hi all,

I have created a database with an MS SQL (2005) backend and an MS Access
2003 front end.
It is used by about 150 users. What I would like is a way to populate a
field in any of the tables that will auto populate with the user's user ID.
I have also heard that the user IDs live in an area of the computer known as
the Active directory and that it can be used to retrieve and record the user
IDs as required.

Any help with this would be greatly appreciated.

Thanks in advance to anyone that can help me.

Regards

JT
 
JayTee said:
Hi all,

I have created a database with an MS SQL (2005) backend and an MS Access
2003 front end.
It is used by about 150 users. What I would like is a way to populate a
field in any of the tables that will auto populate with the user's user
ID.
I have also heard that the user IDs live in an area of the computer known
as the Active directory and that it can be used to retrieve and record the
user IDs as required.

Any help with this would be greatly appreciated.

Thanks in advance to anyone that can help me.

Regards

JT
Click to expand...


There's code to retrieve the users network login name at the following URL
....

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