Anyone that has set up Jet security on an application knows how difficult and confusing it can be.  The Security Wizard is a tool that will allow you to setup your own security mechanism in your Access application without having to implement Jet security.  Running the wizard from Tools/Add-ins/Security Add-In will copy several objects into your application.  It will drop a table (tblOperators) into your application that will contains the list of users of your app and their password (passwords are encrypted using very simple XOR encryption.)  Also, it will drop several modules, two class modules(GlobalProperties and SecurityClass) and one standard module (basMiscSecurityFunctions).  (NOTE:  The basMiscSecurityFunctions module has an IsLoaded function in it.  If you already have an IsLoaded function in your application you will needed to delete if from the basMiscSecurityFunctions module.  Delete the function only, not the whole module).  Also, several forms are added to your project.  Three of them (frmCreateUser, frmChangePassword,  frmGetUserName) are used by the class module.  The fourth form (frmEditUsers) can be used to manage the user accounts (make users administrators for example).

Once you run the Security wizards you add the following to the startup procedure of your application:
PWs.ConfirmPassword

Once the user logs in you can query there user name or authority using several GlobalProps properties as follows:
If GlobalProps.Administrator = True Then ...  
or 
If GlobalProps.CurrentUser = "JohnS" then ...

For more information the Security Add-In please click here or read the help file that is distributed with the wizards.

To view/download the tools you must be a registered user.  If you are registered user you will see a hyperlink to the downloads page below.  Otherwise, register on the site and come back to this page.