LASSIE (LIGHT APPLICATION SECURITY) FOR MS ACCESS 4.3

A library you can reference to implement form/rpt level security in MS Access.

LASsie (Light Application Security) is a Microsoft Access Add-In that enhances your Access application with a simplified user security system. Intended as an alternative to Access’ built-in security, LASsie offers a less complicated way to secure forms, reports, controls and certain records from unauthorized user access. With LASsie, you can prevent a user from opening specific forms/reports, restrict their ability to update data on a form, disable certain controls, filter certain records, all based on a user’s assigned Security Level.

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, if data updates are allowed, and more.

LASsie is called "light" application security because it is not intended to be a robust, 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 linking to them in an external, encrypted database, you could minimize the possibility of such potential breaches, but you should understand that we do not guarantee that such a breach will never occur. That being said, LASsie can serve quite well as an application security system where users are relatively unsophisticated, or where application data is not of a highly classified nature.