Password encryption for Access application

[Sheena_2121]

Dear Alll,

Expect a helping hand from all of you... I am in the mid of designing a Leave Automation application(MS ACCESS..VB code)

Now in the first screen is User logs into the application

Gives User Name
Password.

Now what is the password protection or encryption which needs to be used .....

[CreganTur]

Welcome to the forum! always good to see new members.

There are 2 ways of handling this.

If your login screen is cutom made to reference a table of usernames and passwords, then you would want to use the Password Input Mask for the password field in your table.

Access has built in security features that allow you to setup usernames and passwords, as well as setup permissions for the various workgroups you create along with their associates users.

Take a look at the User-Level Security Wizard for this. There is good information in Access Help about setting up this type of security, as well as good resources on the Web.