Best way to save/retrieve user information after login?

[munkee]

I use a custom login system within access 2003. I have the form currently matching the username and password supplied against a table. I want to then retrieve and store other information within this table such as the GroupID and AccessID which I will then use to lock down buttons and forms from unauthorised users.

What is the best way to retrieve and store this information so that I can check it for use later on?

Any examples are very much appreciated.

Thanks,

Chris

 

[boblarson]

Well, I think "Best Way" is a bit subjective, but I like to use a hidden form with unbound text boxes on it. Then I can, when the database opens, set those to the values and they are an easy source and don't lose their values due to scope issues. You can also, if you wish, use the form references inside queries, etc. directly.