Restrict Users to Their Information Only

[Guest]

Here's a newbie question? I have a database that is used by several people
to log their work. Unfortunately, every one can see everybody elses work log
items. I would like for each individual user to only see their data and no
one else. Also, the supervisor of each individual would need to see all of
his or her employees work log items. What is the best way to do this? A
query or a linked database.

Thanks

 

[Wolfgang Kais]

Hello "Ranger7957".

Here's a newbie question? I have a database that is used by several
people to log their work. Unfortunately, every one can see everybody
elses work log items. I would like for each individual user to only
see their data and no one else. Also, the supervisor of each
individual would need to see all of his or her employees work log
items. What is the best way to do this? A query or a linked database.

Since supervisors need to see several employees data, it will be best
to store all information in one database. You will have to secure the
database so that no user can open a table directly and you will have
to create special queries that retrieve only the rows for the current
user (or if he is a subervisor, the query should retrieve all of his
or her employees data (read only?) The queries will use the "with
owneraccess option" and therfore you allow data access only through
these queries.

 

[Guest]

Wolfgang Kais,

Thanks. I'll try that.

Hello "Ranger7957".



Since supervisors need to see several employees data, it will be best
to store all information in one database. You will have to secure the
database so that no user can open a table directly and you will have
to create special queries that retrieve only the rows for the current
user (or if he is a subervisor, the query should retrieve all of his
or her employees data (read only?) The queries will use the "with
owneraccess option" and therfore you allow data access only through
these queries.