Access Database Users And Permissions Example

This post is a compilation of two of my previous posts:

http://vbahowto.com/ms-access-object-security/

http://vbahowto.com/ms-access-login-form-revised/

This elaborates on the two posts a bit:

First, here are all of the database objects:

access_database_users_and_permissions_list

There are 2 tables here:

tblLogin and tblAdmin

Here are the main forms:

frmLogin – this is the form that opens when the database opens

Here is the code that gets executed when the “Login” button is clicked:

The way it works is that the “tblLogin” table is checked for the existence of the user entered into the form. If a user record is found, they can proceed.

THIS FORM IS LOADED AS A DIALOG FORM WHEN THE DATABASE IS OPENED:

Once that form is passed, the user goes to the main user form, “frmMain”

The administrators form is called “frmAdmin”

Here the admin can add and modify user access rights to the forms and reports.

Here is the code:

This form will open another form called “frmRegister”, which will allow you to enter new users:

This is the code that executes when you click the “Register” button:

That’s about all. I’ll load the database for you all here below.

Let me know if you need help.


 

Here is the database access database users and permissions.accdb

Free! Subscribe To Our YouTube Channel!

facebooktwittergoogle_plusredditpinterestlinkedinmailby feather
Tags: ,




 

Call Erik Now