Security

[Guest]

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!

 

[Rick Brandt]

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!

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.

 

[Joseph Meehan]

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!

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.