User Level Security...HELP WANTED!

[jepoysaipan]

Hi Guys,

I have this problem that really took meoff the hook for quite sometime now, I almost surrender on this task, so please bear with me and your HELP is really appreciated.

Here it goes....

I have a table which consists of DB Users (User Name, Password, User Level), also a table for all the cars available (Car Class, Model, Price etc.).

What I want is to limit a user depending on his/her user level:

User Level = 0
Can Add, Edit, Delete all records
User Level = 1
Can only Add Car Class "B"
Can only View Car Class "A" & "C"
User Level = 2
Can only Add Car Class "C"
Can only View Car Class "A" & "B"

I already search a lot of forum, but can't get the result, Also tried the SimpleLogin example of Bob Larson, but doesnt quite fit.

Any help is highly appreciated!

I am inluding the DB which is in Access 2003 for reference.

Thanks in advance.

Jeff

 

[wiremonkey22]

How do you plan to have the user login once you figure this out you could use a select case

This will not work for your situation until you find a way to tell the system who and what level its looking at however once it knows what level the user has this is an idea
not a solution.

Private Sub cmdEdit_Click()
Dim db As Database
Set db = CurrentDb
Dim rst1 As Recordset
Set rst1 = rst1.OpenRecordset("User")

Select Case rst1!Userlevel

Case 0
Me.Form.AllowAdditions = True
Me.Form.AllowDeletions = True
Me.Form.AllowEdits = True

Case 1
'what you want them to be able to edit here'

Case 2

'etc.. etc..'

End Sub

There are many other ways i have a sample of what im talking about of course its at work will try to get it to you..

 

[speakers_86]

You beat me to it!

You can try my replies in this thread. Each different case should open up frmhome. Have one frmhome for each type of user. Well, thats how I did it anyway.