Security & Permissions

  • Thread starter Thread starter adribog
  • Start date Start date
A

adribog

Hi There

I am hoping someone can solve this problem if possible. I hav
designed a database on Access 2002 and it sits on Windows2000 networ
with approximately six users.

It is designed to track Sales & Service. I created one form t
enter in the Sales information and any service needed for tha
person. Now I am having a problem with Service people changin
information in the sales portion of the form.

Can I assign passwords for each department? Entry still on the sam
form or separate? Someone please help, they are driving me crazy
lol

Thanks
Adriann
 
You'd have to implement user level security and implement a Sales and a
Service group for the different roles. You don't mention whether the
Service Group actually needs to see the Sales group data. If they do, it
will probably make a difference in how the form needs to be designed. But
one possibility is to change the recordsource for the form based on the
group the user is assigned to...omitting the fields that service is not
supposed to edit or basing them on a read only query.
 
Access security has user and groups and you can control access to objects.
This is daunting unless you are experienced. Here is a less sophistocated
approach that works well for me. If you know who logs in, you can control
access to any control to the individual level, though a group level may be
more practical. If the database is secured, users have to log in and you can
get their username using the currentuser() function. Or, create a login form
that captures the user's name. Once you know who they are, you can look them
up in a table and determine if they belong to one or more groups. For
exampe, blnAdmin, blnSales, blnService, etc. These are True/False fields in
a user database. I set public (global) variables usrAdmin, usrSales,
usrService which are tested by code in each form. I have the Form_Current
event call a function, SetPermissionsAndControls, where I set attributes for
various controls on the form based upon the user's permissions. For example,
if usrService then txtServiceField.enabled = true esle txtServiceField =
False. Alternately, txtServiceField.enabled = usrService. Shorter, but the
first example may be easier to understand. This approach can be used to set
all kinds of attributes for all the controls. Hope this sparks some ideas
for you.
 
Back
Top