Controlled access to forms

[Rameez]

I have a login screen at the beginning of the application...once the user logs in...I have to look for his/her credentials in the login table...say if he is "admin"...he should have access to all forms. If he is a user with "vendor" credentials...he should see forms specific to vendors.



how to do this....?
Please help...Thanks in advance...

[RuralGuy]

I have not used it but have you looked at User Level Security (ULS)? I believe it has these type of features built into it.

[marianne]

yup ULS have this features Rameez. but you can always built also your own custom security like what is in your mind, coz I have done that. but as of now I am studying ULS because I want my database objects to be secured from entering into.

[Rameez]

Thanks for the ideas....I will definitely look into user level security...

For now...I figured out a way...I would like to put it here...so that it may be of help to others.(I don't think this the best way but...)

In the login form's code...after validating the login...I have taken the Credentials(role) of that user and the name of that user into a variable defined in a module...using [Call getrole(rolename)] and then called the setrole and setuser functions when I need them.

My Module code is here...

Option Compare Database
Public role As String
Public user As String
Sub getrole(role1 As String)
role = role1
End Sub
Sub getuser(user1 As String)
user = user1
End Sub
Function setrole() As String
setrole = role
End Function
Function setuser() As String
setuser = user
End Function

[marianne]

so how is it accomplished?

[Rameez]

actually user level security may not be an option for me...as i want the database to work in different machines...and i won't be the one granting access to the database.

should I mark this as solved...as i have the remedy for this issue.

http://databases.about.com/od/tutori...ersecurity.htm

The above link has info on ULS...In case any one needs.

Thanks Marianne and Rural Guy(Allan)

[marianne]

yup. this ULS maybe option for the other and not for the other. but as I know even if you use the ULS, you can still use that database to work in different machines. you just need the .mdw file made in ULS to accompany your db.