Security and calculating problems - Access 2000

[jamiesuperman420]

Hello... I'm setting up a database for a property maintenance company that has one "main page" to display the different services with fees, schedule, etc, etc. Included in that mainpage are some basic calculations - adding up service totals for the property - and the like.

Today I added multiple users and ran into a problem. I don't want many of the users to be able to change the code or input information - so I limited their ability to update the form. However, because I'm giving fields values with those basic calculations (eg: if such-and-such>0 Then [LSActive]=True), the page won't load correctly and loses it's functionality. Those simple calculations are considered updating.

I know this isn't a great explanation - but I was hoping someone out there might have a suggestion for me. If someone isn't allowed updating, are they still allowed running Queries and are those results allowed to be displayed??

Thank you very much.

 

[jwhite]

You haven't mentioned how you limited their ability to update the form. What I would surmise is a Private Sub in your code module of the Form named (perhaps) "LockControls(blnState As Boolean)". In this procedure you would have each Control like "Me.ControlName.Locked = blnState". Whatever means you have to identify a restricted user, then issue "Call LockControls(True)", else "Call LockControls(False)". Controls that are .Locked=Yes can still be updated.