Field Permissions

[Purpleswanage]

I have written a database to track Errors, New Requirements and Requirement changes in the software code our programmers develop. I have secured the database using the in-built Security Level Wizard using the "Full Permissions" group for those I trust not to fiddle and the "Full Data Users" for everyone else. (This was before I found this forum and the very excellent advice on VBA)

The latest 'enhancement' they have come up with requires field level permissions to be set. They want a permission group for the change control Board (CCB) where they have specific permission to change the value of certain fields and not the general users to prevent the programmers arbitrarily closing actions without review. Is this level of permission setting possible? Where do I start? Do I have to get rid of the Wizard settings and start again in VBA? If code is the answer, where do I put it?

Any advice or examples would be most welcome.

Helen

 

[csrjw]

Helen, I have created something similar. I have a field on a form that is composed on document creation. Once the user saves the document, when they go back into it, they cannot edit the specific field. Everything else they can edit. I have a button on the form, prompting the user for a pre-defined password. Upon validation, the field that was once locked, because available to the user with the correct password. Is this what you need?

 

[gemma-the-husky]

in this case have two tables with a one to one join

put the locked fields in one table, and the unlocked fields in the other.

you may be able to get what you want without complicated password handling etc