How do i know who is logged into my database

[Guest]

I have set up security on my database, with permissions to various users, but
I now need to know who is logged in, and when. any ideas how i can do that?

 

[Scott McDaniel]

I have set up security on my database, with permissions to various users, but
I now need to know who is logged in, and when. any ideas how i can do that?

You can use the LDB viewer if you're running A97:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q176670

If you're running 2000+, you can use the code found here to build your own utility:

http://support.microsoft.com/default.aspx?scid=kb;en-us;285822


Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Guest]

Is it possible to put this on a "button" so that users can also view it? I'm
very new to Access (2003) and have never used VBA in my life, so any info you
can supply will be of great help

Thanks - Sarella