How do i know who is logged into my database Sarella 05.06.2006 15:08:01 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?

Re: How do i know who is logged into my database Scott McDaniel <scott[ at ]NoSpam_Infotrakker.com> 05.06.2006 20:50:34 On Mon, 5 Jun 2006 08:08:01 -0700, Sarella <Sarella[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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[ at ]takemeout_infotrakker.com www.infotrakker.com

Re: How do i know who is logged into my database Sarella 12.06.2006 10:30:01 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 "Scott McDaniel" wrote: [Quoted Text] > On Mon, 5 Jun 2006 08:08:01 -0700, Sarella <Sarella[ at ]discussions.microsoft.com> wrote: > > >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[ at ]takemeout_infotrakker.com > www.infotrakker.com >