rkmorrow (MIS) Feb 15, 2002
I have an access97 database that was created by a company for a smart card system.
The database holds client information: name, ss#, home address. There are counselors for the clients that also have been input into the database. The counselors are concerned that their own information can be read by anyone (other counselors)that can access the databse.
I don't know that much about databases, but the forms have a field for inputting a code number on the accounts. It seems that I should be able to apply a code number, say 99 on the counselors accounts and lock them from anyone viewing those accounts except administrators.
Is there an easy way to do this?
Thanks for any input
rkmorrow
I have an access97 database that was created by a company for a smart card system.
The database holds client information: name, ss#, home address. There are counselors for the clients that also have been input into the database. The counselors are concerned that their own information can be read by anyone (other counselors)that can access the databse.
I don't know that much about databases, but the forms have a field for inputting a code number on the accounts. It seems that I should be able to apply a code number, say 99 on the counselors accounts and lock them from anyone viewing those accounts except administrators.
Is there an easy way to do this?
Thanks for any input
rkmorrow
