Multi Level User Login

[joycesolomon]

Hi,

I have a project with Access frontend and SQL as the database.

I need to create a login screen with 4 level of users (admin, creator, contributor, and visitor).

I have not done this before....and of course each level can do different manipulation with different forms. Can someone please help or give me some example.

I have created my Login table with ID, Username, Password and checkboxes for (Admin, Creator, Contributor, Visitor). Is this the right approach?

 

[BigRed1212]

I don't know about "right", but it seems a viable approach. I hate checkboxes so I would just use a numeric 1 or 0 but logically its obviously the same thing.

Don't know if this is a Web application hit in a browser or just what.

Assuming a Web page, user logs in, you verify username and password to authenticate, grab user permissions. Probably stuff the info into some sort of session variables and then use condiotional logic to display what should be shown and not show what shouldn't be shown.

If it is a standalone Access database application thing, I know less about those but would assume there is some way to display different screens based on different permission levels.