I tried making my own security for a databse of mine, and I have a recurring problem.
In order to keep the state of security, I use a variable to hold what security level this user has. For some odd reason every so often the variable will sort of lose this value, and in essence log a person out (I have as a default no permissions if there is no value in this variable).
If anyone can please explain to me why this might be happening, or maybe even a fix, I would greatly appreciate it.
In case you were wondering why I made my own, I did this b/c I didn't want all access databases under this security.
Bauer
In order to keep the state of security, I use a variable to hold what security level this user has. For some odd reason every so often the variable will sort of lose this value, and in essence log a person out (I have as a default no permissions if there is no value in this variable).
If anyone can please explain to me why this might be happening, or maybe even a fix, I would greatly appreciate it.
In case you were wondering why I made my own, I did this b/c I didn't want all access databases under this security.
Bauer