The one I am going to demonstrate must not be the best, but will fulfill your basic requirements.
User_Type is to navigate to different Form for different people. In the Design View, you just need to make three Control: – two Text Box, one is for login ID and the other is for password.
– login Button to verify password and navigate to the next page Below is an example of a login Form.
I am looking for a simple method possibly using a combination of VBA with Windows API inside my Microsoft Access database application to validate a user's keyed-in password with the password they use to login to their Windows account. You Access database is not really protected if you are using Windows login account and password.
It means everyone on the network can access the Database since they all know their password.
To add validation rules to a table, you open the table and use commands on the Fields tab of the ribbon.