Home Grown Security Question

[etrain]

I have developed my own security functionality primarly becuase I did not need all the features of the access delivered. That is beside the point really.

I have a couple questions. First, the users when they open the application are prompted for a password and user id. When they click LogIn and everything passes the security check another form is opened in hidden mode. This hidden form stores the users name, ID and workgroup of the person that just logged on. This allows me to use this information easily from my forms and the rest of the application by just referring to this hidden form. It is sort of like the using CurrentUser() when you have Access Security implemented. I started out doing it this way becuase it was the first thing I thought of and it works.

Question I have does anyone have a better suggestion or way of storing/logging and then recalling the user information when needed rather than having a hidden form open?


Question 2 is have is more along the lines of Constants/Variable kind of question so I will post it seperately.

Thanks Remember the Past, Plan for the Future, yet Live in the Now for tomorrow may never come.
-etrain

 

[TerpFan2001]

Etrain:

You could always just store the info in public variables in a module after the user logs in. That way you could still access the information without having to keep another form open.