I've got this little challenge this week.
I do have a MS Access built in 2003 using security workgroup. There is a function called "displayRights" with the following attribute
Public Function displayRights (userName As String) As Boolean
displayRights = GetUserBoolValue(userName, "DisplayPrices")
This is used to get the logged in username from that Workgroup and determine if he can access the price tags in other forms where VBA calls this variable.
What I would like to do is to create the same global variable (instead of changing the whole vba on each form.
I have create a login form, that calls a table where is myUser and myPassword. In the same table there is a field where I do specifiy (0 or -1) if the logged in user has right to access price tags.
The question is How can I store this login information so I can call it every time a form is opened and make sure the proper right is applied.