can i use tempvars to keep me logged in?

[Ryno Bower]

Hi
Can someone tell me if I can use tempvars to keep me "logged in"?

What I mean is, when I log in from my login form can tempvars help me so that whatever I do that my name would be linked to it?

Do you think it can help me to set up privilages that way too?

[NeoPa]

If you are setting up your own security system then yes. You can use a variable (or variables) to store relevant information about your security level.

As the security is only for the current session though, you will need to ensure the scope and the lifetaime are both appropriate. The variables need to be available to all places that need to check them. This could be all encapsulated in its own module, or it may be freely accessible to all your code. If the former, then the variables would need to be visible to that module. If the latter then they would need to be defined as Public in a standard code module.

Remember also the lifetime of the variables. Anything within any procedure, except when defined as Static, will disappear as soon as the procedure completes execution, and will therefore lose your stored data prematurely.

There are many design choices, you need to choose which to use for yourself. My recommendation is that you consider your options carefully before deciding. Design the concept before starting to code it in.

Good luck.

[Ryno Bower]

Hi, thanks for your reply.

However, I have no clue how the tempvars is working. I will try and do research and do whatever I can. If I don't succeed in getting it to work, would it be ok to attach the database to this thread ask you to have a look and help me get the coding to work properly? I guess wheb you see the db you will have a more clear idea of what I'm trying to do.

Should the field be on every form that I want the tempvars to show though?

Waiting for your reply, thanks.

Ryno

[NeoPa]

I'm sorry Ryno, but I'm not interested in working that way. I answer clearly-stated question on the forum, and that keeps me quite busy enough thank you.

I expect we would have problems communicating anyway, if the answers I've already given are not enough to get you going. As I already stated, it is critical that you get the design right before you start, or you will waste much time struggling with things that won't work properly.

[Ryno Bower]

Well, if I don't succeed is there anybody else that will jelp me that way? This is a question to all the other forum users.

Thank you very much.

Ryno