Since Microsoft dropped User-Level Security (ULS) in Access 2007 and its successors, developers have been left to their own devices to figure out how to implement security.
Now basic login forms can be pieced together relatively easily, but controlling users’ access to various database objects (forms and reports) and controlling what each user can do (create, read, update and delete) within each is another thing altogether to say the least.
Now, thanks to CARDA Consultants’ Inc. Security Database you can implement security once again. The modular and granular system has 5 primary components to it:
- Group Permissions
- User Groups
This approach does not require a login form. Instead, it uses the user’s windows login to identify the current user and authenticate them automatically. One less username and password to remember, your users will be grateful!
Once implemented into your database, you will be able to lock down any form or report with a single line of code!
You define all the various permission profiles for each database object (forms, reports)
You define groups
You associate the permission to your groups
You create user accounts
You assign groups to each user.
A user can be a member of as many groups as you want and the permissions are cumulative.
Securying Your Forms and Reports
Import the required Security Management Forms,VBA Modules, Configure your security settings (Permissions, Groups, Group Permissions, Users, User Groups) and then you can secure each of your objects with a single line of code using their Open events.
Take it for a Test Drive
Feel free to download a locked down accde version of the database to try out by using the following link.
Purchase MS Access Security
MS Access Security – Version 1.00 (accdb x32bit database format)
If you do not have Microsoft Access, simply download and install the freely available runtime version:
Although we have taken steps to ensure that the software on this site is free of viruses, we provide the software ‘AS IS’ and we recommend you take the time to scan it again.
In no event will CARDA Consultants Inc. be liable to the client or any third party for any damages, including any lost profits, lost savings or other incidental, consequential or special damages arising out of the operation of or inability to operate the software which CARDA Consultants Inc. has provided, even if CARDA Consultants Inc. has been advised of the possibility of such damages.