User ID field

[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

 

[Brendan Reynolds]

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

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

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