LASsie (Light Application Security) is a library of Microsoft Access objects that you can reference from, or add into your MS Access application to implement basic form level security. With LASsie, you can prevent a user from opening specific forms/reports, or restrict a user’s ability to update data on a form.
LASsie includes a friendly user sign-on form that prompts for a login user name and password. Users can change their own passwords via the included "change password" form. Optionally, the sign-on form can be bypassed and the user's network login username can be used. Once the user name is verified, his/her session is assigned a security level code that determines which forms or reports can be accessed, and if data updates are allowed.
LASsie is called "light" application security because it is not intended to be a robust, crack-proof, high-end security application. In fact, a sophisticated user could edit the underlying tables and change their own security level. By hiding the LASsie tables, and/or putting them in an external, encrypted database, you could minimize the possibility of such potential breaches, but you should understand that using LASsie does not guarantee crack-proof form/report level security. That being said, LASsie can serve quite well as an application security system where users are relatively unsophisticated.
|