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

User Groups

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.

Download “MS Access Security (x32 accde database format)” Security_fe.zip – Downloaded 98 times – 124 KB

Purchase MS Access Security

MS Access Security – Version 1.00 (accdb x32bit database format)


Price: $299.95


Notes:

All sales are final and no refunds will be issued as the deliverable provides the complete source code.

If you do not have Microsoft Access, simply download and install the freely available runtime version:

MS Access 2007 Runtime
MS Access 2010 Runtime
Ms Access 2013 Runtime
Ms Access 2016 Runtime

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.