Get User ID

[Nick]

I am wanting to have a field in my database that displays
a list of the current users on the database. I am
strugling to write this code.

Cheers

Nick

 

[Rick B]

You would have to store the information somewhere. The best way is to
create a hidden form that opens when the front-end is opened. In the form's
open event, write code that stores the UserID (and date and time) to a
table.

On the form's close event, delete the record from the table, or update it to
include a time and date logged off.

This will work pretty well, but if Access crashes, the power goes off, etc.
then the table will not be accurate and you will have to fix it. I gues you
could make your open code look for any bad records for the user in the table
and delete them?

Rick B




I am wanting to have a field in my database that displays
a list of the current users on the database. I am
strugling to write this code.

Cheers

Nick

 

[Reggie]

Nick, Here's a good place to start
http://www.mvps.org/access/general/gen0034.htm