Low Level Form Security

[khunter]

I have a db with low level security (A table contains a username, password and access level).

The database startsup with the login form and asks the user for the input. I would like to know if it is possible (if so where to start) to hide and/or restrict users based on the value of the access level in the table.

Thanks in advance.

 

[brian0721]

Hide or restrict them from what exactly? From the entire DB? Could you explain a little more.

Thanks

 

[khunter]

I would like to hide buttons and forms based on what access level that user has. i.e. If a user has "Admin" it would allow the form to be run, but if they had "Basic User" it would reject the request.

tblUsers:
strUserName
strPassword
strAccessLevel

If User A logins and has "Admin" in strAccessLevel I want the form to show button1, if it doesn't contain "Admin" do not show it..etc...

Hope that is a little more detailed.

Hide or restrict them from what exactly? From the entire DB? Could you explain a little more.

Thanks