asked on

Login script with restricted access

Hi,

Grateful for some advice:

My problem or thought process is the following:- (using MS A03)

I have a simple database . One table has a number of fields.
Groups of records have the same value for a particular field...In other words
record1, field x has value A
record2, field x has value A
record3, field x has value A
record4, field x has value B
record5, field x has value C
etc...

Several users have access to this database but each user can/should only see records of a particular value for field x...in other words
User Bob should only see the records of field x with value A
User Tom should only see the records of field x with value B
etc...

My idea is to create a login form based on a username and password which would be looked up in a separate table. Once the username and password is verified, the process/routine would then only allow access to the records he/she is entitled to view and/or amend.

Is this feasible and /or is there a better way of addressing this problem?

Thanks (I am willing to go into more detail)

ASKER CERTIFIED SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Scott McDaniel (EE MVE )

Note too there is at least one commercial product for this:

http://www.peterssoftware.com/las.htm

You'd still have to implement the data restrictions, but that product will create the basic infrastructure you need to manage this.

PipMic

ASKER

I Need to tweak the code