Who is logged In?

[Emma Hope]

Can anyone tell me if there is a way of finding out a list
of users who are currently logged into a secured database.

If this is not a automatic feature of access, is it
possible to set something up so that a record is created
in a table that lists the user and the time they last
logged in and then deletes (or amends with log out time)
the record when they close the database (they can close
using the x in the top right).

Also, i have made a number of changes to my secured
database and i would like an unsecured copy, is it
possible to do this somehow. I know when you run the
security wizard it creates and unsecured backup however if
i do this will any of my security groups or user
permissions change?

Thanks
Emma

 

[Tony_VBACoder]

First, Login/Logout times will have to be handled in your
Front End application once the user logs in via the Access
Security built in form. Access does not track these
login/logout times. During your initialization routine,
run a SQL statement to lookup the CurrentUser() in a user
table you have created and log the currentdatetime in
another UserLog table.

Second, here is a great example of how to find out who is
logged on and will get you started:
http://www.mvps.org/access/general/gen0034.htm