MS Access restrict user access to a form
Posted on 2014-01-03
I have a user table which holds users name, unique Id and other details.
I have a main form accessible to all. On this form I would like to add a button which gives access only to the users from the UserTable.
I have a function which retrieves the user ID from the system as the users will use the database from their personnal PC. I'd like to compare this id with the ids from my list and open the form if the id matches else provide a popo message saying the access is restricted.
Thanks for your help on this!