LASsie
Download Las.zip (906kb) - for Access 97, 2000, and 2002/XP
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 and/or report 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.
NEW IN VERSION 3: Support for reports, subforms and subreports.
ACCESS 2000 USERS: Make sure you have installed at least Jet 4.0 Service Pack 6 (SP6) in order to avoid this error
