Suggest you look at my password login form example at
http://www.mendipdatasystems.co.uk/p...gin/4594469149
All data tables must be in the backend on split databases.
There are many things to consider in terms of security and no Access database can ever be 100% secure
Suggest you read this article on my website
http://www.mendipdatasystems.co.uk/c...ity/4594444323.
Using a SQL Server BE will be more secure for your data.
In term of securing the FE, there are many things you should do as well as using password login.
For example, use ACCDE to protect code, remove the navigation pane, ribbon, disable Access special keys including the shift bypass.
Remove Access options to prevent knowledgeable users reversing all of your security measures.... etc, etc
Suggest you also look at my security challenges for ideas
http://www.mendipdatasystems.co.uk/s...ges/4594398127
In terms of security, it would be better to not store passwords at all.
Instead check entered passwords against those in active directory if that is in use on your network.
If you have to store the passwords, then they should be encrypted using e.g. RC4 cipher. See my example login for this as well
Good luck