who's logged on. Public var or use table.

[Jesper F]

I have a simple system where people log on with passwords.
No access security just something simple I made up.
From time to time I need to know who's logged on to the
system. Right now I'm keeping that information in a public
variable. Which is considered better - what I'm doing now
or to store the value in a table made for this sole
purpose. I'm worried about overhead and whether using the
table might be better.
Thanks for any input.

 

[Lance McGonigal]

On all my systems i use a table. in the table i have time in, time out,
user, machine and id (autonumber). When the user opens the app the menu
enters a record onopen and sets the menu's tag property to the id. When
they quit some code takes the form's tag (the id) looks it up and stamps
them out. I know who's currently in the system by looking for all records
with the time out = null and display it in a msgbox.

Works great for me.