LASsie for MS Access

LASsie is a Microsoft Access Add-In that provides users with an easy and simplified way to secure forms, reports, controls, and certain records from unauthorized access. It serves as an alternative to the Access built-in security system, making it less complicated for users to manage security settings.

With LASsie, users can prevent other users from opening specific forms or reports, restrict them from updating data on a form, disable certain controls, and filter records. This is all based on the user's assigned security level, which can be changed by the user.

The Add-In comes with a user-friendly sign-on form that asks for a login username and password. Users can change their own passwords through the included "change password" form. The sign-on form can be bypassed if the user's network login username is used.

After the user's name is verified, their session is assigned a security level code that determines what forms and reports they can access, if they can update data, and more. LASsie is intended for lightweight application security, meaning that it is not a robust, high-end security application.

More sophisticated users could edit the underlying tables and change their own security levels. However, hiding the LASsie tables or linking them to an external, encrypted database can minimize the possibility of such breaches. It is important to note that LASsie does not guarantee that a breach will never occur.

Overall, LASsie can serve as an effective security system for less-sophisticated users or for applications that do not store highly classified data.