Multi user enviroment

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

Re: Multi user enviroment

"zdenko" wrote in
news:fisjeh$3jc$1@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

Re: Multi user enviroment

zdenko wrote:
> 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
>
>
Check out http://www.mvps.org/access/general/gen0034.htm to determine
who's in the system. 2 options are provided; pre-Access 2000 and 2000+.

As far as logging the info, that's something else. You might find some
code at
http://groups.google.com/advanced_search?q=&oe=UTF-8&hl=en&
Plug in words like LDBView or UserRoster and search from groups *Access*