"zdenko" <zs******@gmail.comwrote in
news:fi**********@ss408.t-com.hr:
Hi,
I have database with four users. Users were created by user-level
security wizzard.
How can I (as admin) know who is using the database and somehow
log this sessions?
Thx
I trigger an insert query to a usage table in the openform event of
the introductory screen of my aplications. It puts the user name and
the current date/time into the record.
Since you have security enabled, a call to the
application.currentuser() function will return who. I don't always
use security, it can still be done by using an API call to get the
current logged in user on the computer.
An update query to the record created above sets the logout
date/time.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from
http://www.teranews.com