see who has program open

[Djblois]

Is there any way to see who currently has my access application open. Either something built into Access or something I have to create with code. I already have people log in using a user name to get their settings and all that but now how can I use that to see if they have it open?

 

[DCrake]

Here is a link to a sample mdb that does what you want

Link

David

 

[brucle]

I created a form with an unbound text box called Logged On.

IN the on open properties I inserted the following code:

Me.LoggedOn.RowSource = WhosOn()

Hope that works OK for you