Tracking who has logged in.

[todays]

How can I grab the enduser's network id and store it in a
table each time the database is opened? Any help would be
appreciated.

 

[Cheryl Fischer]

The code found at the following link will do that for you:

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

hth,

 

[David Dubroff of Mr. PC]

For your information, Microsoft Access also has the ability to use what is
called a "Workgroup" for all users that become joined to the same database
workgroup. On each workstation or the server-based installation, there is a
program known as "WRKGADM.EXE" located in the "1033" sub-folder of the
Access installation. Using this utility, you can get each workstation to
join a common workgroup file. Within this workgroup file, you will end up
creating separate database user names for each user. These user names will
be in addition to their network user name, but you can make these names the
same if you want. Once the user accounts are set up within Access, you can
use a variable anywhere in your Access database to report the Current User
who is using the database. The variable is: CurrentUser

Any field you set to CurrentUser will fill-in the value of the database
workgroup user name that logged in when starting the database file.

To become familiar with database workgroups, I suggest you search the
built-in help within Access for: workgroup