G
Guest
I have an Access database with one table, several forms and several queries.
Each department has a form and a query. I have created users and passwords
when opening the database; however, I need to take it a step further by
limiting access according to the username logging into the database.
For instance, when the VP of the IT dept logs into the database, I only want
him to see the forms/queries relevant to his dept. I need to hide or disable
the other depts information. Does anyone know how to make this work?
Thanks!
Christy
Each department has a form and a query. I have created users and passwords
when opening the database; however, I need to take it a step further by
limiting access according to the username logging into the database.
For instance, when the VP of the IT dept logs into the database, I only want
him to see the forms/queries relevant to his dept. I need to hide or disable
the other depts information. Does anyone know how to make this work?
Thanks!
Christy