MS Access Security Replacement for User-Level Security (ULS)

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:

• Permissions
• Groups
• Group Permissions
• Users
• 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!

Screenshots

Permissions

You define all the various permission profiles for each database object (forms, reports)

Groups

You define groups

Group Permissions

You associate the permission to your groups

Users

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)