Access Database - User Access Control

When Microsoft introduced the Access Database accdb format with version 2007, they effectively removed the ability to natively control a user's access to Forms, Reports, Queries, etc, once they had gained access to the database. You can still prevent a user from opening a Microsoft Access database by encrypting the database with a password, however the latest accdb format of Microsoft Access database does not provide a method to control what forms, reports, and more importantly, which data, a user can access once they have access to the database.

To manually add user access control back into the database requires a significant amount of development work, for which you will need a good knowledge of the Access Database design interface, VBA coding skills, and an understanding of the security holes and weaknesses inherent in MS Access database.

The User Control Add-in, automatically adds all the required tables, forms, and VBA modules needed to monitor and control a user's access to objects (nominated Forms & Reports) in your Access Database. With the User Control Add-in installed you decide which users have access to what data in the database; and can restrict or prevent users from accessing data or functionality they don't require.

Integrating the User Control Add-in requires some understanding of the Access Database design functionality as some settings may need to be adjusted to suit your database. However, if you can follow some simple instructions, it shouldn't prove difficult to accomplish.