Viewing user ID of Users in a DB

The first part's simple. On the main menu form (the one that launches when you open the DB), create a textbox with the expression
=Environ("username"). If you don't want users to see it, set Visible to No.

For the other bit, here's some air code:

You'll need some code that writes a record to a table like tblUserLog:
the table itself probably only needs 4 fields,
LogID (Autonumber)
UserID (Text)
LogOn (Date/Time), default value =Now()
LogOff (Date/Time)

You can write the record using SQL or DAO code; make the routine a function so it can be called from a macro, then create an autoexec macro that runs the function. That will create a new log record when a user opens the DB.

To log off, you need code that finds the user's current record and writes the current date/time to LogOff. This needs to be triggered when the user shuts down the DB.

Then, to see who's on, create a form with a listbox that displays all tblUserLog records where LogOff is Null.

Denis

I have just posted an article on my web site -- take a look
http://www.datawright.com.au/access_resources/access_logging_users.htm

Denis