Password Protecting and limited access to a user 1

[n1a2v3i3n]

Hi,

I am trying to develop a application where i need to give limited user to some of the user and administrator with full access. I am using access as database. Could anyone tell me like how do i keep the user active through out the session until he logs out.

OR

Is there any other way that can solve this problem

 

[Andrzejek]

I would have a table in your Access:
[tt]Login Role
Adam 00
Bob 01
Susie 01
John 01
Bill 02
Janet 02
Barb 01[/tt]

In your VB code you can get the login name of the user who is accessing your database, check it against this table, and based on the ROLE - enable or dis-able certain functionality.

You can give Adam (administrator) ability to add/remove users from this table.

As you can see you may have many different people with the same ROLE, and many different ROLEs as well.

Just a suggestion…..


Have fun.

---- Andy

 

[n1a2v3i3n]

hi Andrzejek,

Well i got you point but wht i want to do is want a particuler user to have limited access throught the session until he logs out and the admin can have full session. So is there any way for that

 

[Andrzejek]

What do you mean by "a particuler user to have limited access throught the session until he logs out"?


Have fun.

---- Andy

 

[valgore]

so i just finished doing this in my database. little background.
I have a logon form so each user can log in. then i have a startup form that starts when the user logs in. there are buttons on the form that let people either import something or access a table. i wrote code based on their "security Code", which is just a number i input into a field, that disables/enables buttons depending on their security code. is this what your looking for? because i can give you the code that i have

Valgore

 

[Andrzejek]

When they log in - how (and where) do you get their "security Code" (from)?


Have fun.

---- Andy

 

[valgore]

ok. let me back up. i created a table with three fields. username, password, and security code.

sorry if that confused you

 

[Andrzejek]

That's OK, if that works for you then it is what you want.

I would not store a password in my table thou. And I would detect the UserName (from Windows) instead of asking for it, but that would make me happy.

You need to do what works for you.

Have fun.

---- Andy