Current Users Logged Into Database

[Gary_Mc_Mahon]

Hi,

Can anyone help. I want to run a query which can tell me anyone currenly logged into my database using Environ("USERNAME"). Any help would be great.

Gary

 

[Andrew Fergus]

Hi Gary, I'm not familiar with this function but this page looks like it might be useful.
HTH, Andrew.

 

[bat17]

If you are trying to find out the current user then Andrew has pointed in the right direction
If you are trying to find out all the users who are using a multiuser db then things get more fun

There is a Database here that will let you see who is using databases, this may be what you need or you may be able to find some help from it.

http://www.fabalou.com/FullPrograms/Dblauncher.asp

HTH

Peter

 

[Gary_Mc_Mahon]

Thank you both, I have come up with a solution.

I have a form which opens on start. Then I have an on open procedure which records the envoirn("username"), date time, stauts="LogIN" in a tbl_log.

I then have another procedure that runs when the database is closed which records the envoirn("username"), date time, status="logOut " in same table.

Then I run a query to return the max date of of a username in the tbl_log, and match that to the status which will tells if the username is loged in or out.

Bit long winded, but works a treat!!

Gary