The security features available in Access are extremely rich. Being able to implement security using both code and the user interface gives you immense power and flexibility when implementing security in your application.
This chapter began with a look at maintaining users and groups using code. Next, you learned about using code to assign and maintain passwords, as well as determining whether a user has a password. You also learned about assigning and revoking permissions to objects using code, as well as many other advanced techniques that give you full control over security in your application.
Security requires a lot of planning and forethought. You must make decisions about what groups to define and which rights you will assign to each group. Also, you must decide what features you will build into your application using VBA code. This chapter illustrated how you can build all aspects of security directly into the user interface of your application.