MS Access Global Variables, Timeouts, and Security
Posted on 2014-10-08
I have an application that I am building that has a low level requirement for security. I am planning on having a user table that stores login IDs, passwords, and security information about what objects they can access and what they cannot.
Upon successfully logging in, I was going to store their USERID in a global variable to be available throughout the application.
If I do this, can the application timeout such that the Global Variable loses it's value?
If so, what is the timeout period?
Any finally, is there a better way to store this info as they navigate and use the application?