Newbie: Issues DB and Security

[pwt]

I am using the Issue Tracking for Access 2003. I have users that I only want
to be able to modify the Status field of any issue (i.e. change from Active
to Deferred) -- everything else should be read access. I have tried several
combinations on the User and Group Permissions dialog for the user, but I
cannot seem to find the right combination. Should I be able to do what I
want? If so, how? Thanks for any direction. I am new to this.

 

[Tom van Stiphout]

On Wed, 14 Apr 2010 12:01:01 -0700, pwt

I would not use the User and Group Permissions. This is for User-Level
security, but it is an advanced topic you cannot simply click-click
your way through and hope to be successful.
And even if you applied it perfectly, it works at the Object level,
not at the Control level.

Rather keep it simple and write a few lines of code. First you need to
ask Windows who is logged in. See this code:
http://www.mvps.org/access/api/api0008.htm

Then in the Form_Open event of your form write some code like this:
dim isReadonlyUser as boolean
dim userName as string
userName = fOSUserName()
if username = "JJones" or username = "SuzyQ" then
isReadonlyUser = True
else
isReadonlyUser = False
end if
Me.myFirstControl.Locked = isReadonlyUser
Me.mySecondControl.Locked = isReadonlyUser
Me.myThirdControl.Locked = isReadonlyUser
'etc.
Me.myStatusControl.Locked = False 'all users can modify Status
(of course you replace myObjectNames with yours)

-Tom.
Microsoft Access MVP