Security

B

BeeJay

I was wondering if anyone could help me...

I have database with a simple log in front end on it, to which users select
their name from a combo box and then enter their password. I was wondering
if there was a way to grant access rights on log in for example user A logs
in with normal user rights, but user B logs in they are granted Admin rights.
I hope this makes sense and some one can help me.

Thanks in advance!
 
R

Rick Brandt

BeeJay said:
I was wondering if anyone could help me...

I have database with a simple log in front end on it, to which users select
their name from a combo box and then enter their password. I was wondering
if there was a way to grant access rights on log in for example user A logs
in with normal user rights, but user B logs in they are granted Admin rights.
I hope this makes sense and some one can help me.

Thanks in advance!
Click to expand...

You can certainly store who the user is with a hidden form control or in a
public variable and use that to determine what they can and can't do within the
app. Be aware though that such "home-grown" security is trivial to bypass by
anyone with a smattering of knowledge about Access.

For example anyone could import or link to your users table and have all the
passwords. While not unbreakable you really should use the built in Access
Security if you want something more than a paper bag with a lock on it.
 
Top