Limiting access to specific forms/queries.

[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

 

[Scott McDaniel]

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.

Are you allowing users the see the database window? In general, that's NOT a good idea (since users will invariably
figure out how to unhide the other items).

Instead, a better idea is to build a menu/switchboard system that helps guide the user to their correct forms and
reports. There are a ton of switchboard examples around, so I won't go into great detail about it, but basically you (a)
log the user in and then (b) open the correct switchboard, with the relevant buttons enabled and visible. For example,
you may allow Accounting to see the Employee and Orders forms, but not the Inventory forms ... so you'd provide a
switchboard for Accounting that only allowed them to open those two forms ...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com