Current Users Logged Into Database

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

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

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