Security

[Guest]

Hi,
Is there a way to restrict the records a person can view beased on the user
name and password he supplied while logging in to the acces database. I ma
looking at a situation wherein a person will be able to see and modify only
the data entered by him and not by anyone else.

Thanks for the help
Venki

 

[Rick Brandt]

Hi,
Is there a way to restrict the records a person can view beased on the user
name and password he supplied while logging in to the acces database. I ma
looking at a situation wherein a person will be able to see and modify only
the data entered by him and not by anyone else.

If you store the user name in all records as they are created then you can use
queries that apply the user name as filter criteria. This assumes that you are
implementing Access User Level Security. When doing so the CurrentUser()
function returns the Access account name that is currently logged in. You would
then need to deny rights to the tables directly and use "Run With Owner's
Permissions" queries for all data access.

You could do something similar with a "home grown" login system, but it would be
trivial to bypass by anyone who knows anything at all about Access.

 

[m]

Hi,
Is there a way to restrict the records a person can view beased on the
user
name and password he supplied while logging in to the acces database. I ma
looking at a situation wherein a person will be able to see and modify
only
the data entered by him and not by anyone else.

Thanks for the help
Venki