Hi,

I need to create a data-driven log-in form with different permission levels using classic ASP and MS Access. It is intended for a HR Company.

What I'm trying to achieve is something like the following:

Manager - all access/permission

Staff 1 |
Staff 2 | create, edit and delete vacancies
Staff 3 |

User - view and apply for vacancies

I'd like some help to know which is the best way to achieve the scenario above.

Thanks!

Hi,

I need to create a data-driven log-in form with different permission levels using classic ASP and MS Access. It is intended for a HR Company.

What I'm trying to achieve is something like the following:

I'd like some help to know which is the best way to achieve the scenario above.

Thanks!

Create the following tables (and fields) in your DB: -

Users (UserId int identity, Username, Password, Firstname, Surname, Active, etc...)
Permissions (PermissionId int identity, Description, Active, etc...)
User_Permissions (UPID int identity, UserId, PermissionId)

Once you configure the user's permissions, the login form simply needs to authenticate the user via the Users table. Your login script can then set various session variables which you can check in your code to allow/prohibit HR tasks for each user tasks.

Hope this helps.