Can I limit access to a record with a password? Any suggestions as to how to do it?
Can I limit access to a record with a password? Any suggestions as to how to do it?
You'd need a tUser table,
userID, Rights,key.
the rights field would have a code to limit those to certain areas.
A,admin sees all
M,manager,can see some,
blank,could just allow read only.
but to limit on records, you'd have to give a key value for the record they can see,or a code.
which would mean another table if there are > 1 code/key users can see.