Suppose, I have a Login Form - 2 ways
1) Store UserID & Password in table & then check the values entered in Login Form against them & allow access to the db. ( IMO - Should avoid this but has advantage of simplicity in adding new users )
2) Use VBA Code hard coded with the User Name & Password & probably not accessible once converted to ACCDE.
Am I wrong in choosing Option 2 in the above or are there better ways than the above two?
Next :
Say there are 2 users User1 & User 2.
I have a kind of SwitchBoard Form ( with say 2 buttons, Button 1 & Button 2 ), which is opened automatically, once the User logs in.
I need some guidance with this :
User1 on logging in, should be able to see only Button1 on the SwitchBoard Form
and
User2 on logging in, should be able to see Button1 as well as Button2, on the SwitchBoard Form.
Thanks