Simple Solution To Limit Access to Records

[AllenWWII]

I wanted to share a simple solution to the forum in how I restriced access to certain files.

The database tracks the amount of money a person uses on a shift. The user enters their own information into the record. Once I have checked this information I wanted the file to be "locked" to all users who do not have admin privileges. This may be useful to those how monitor their database on a daily basis.

First off there are two privilege sets: Admin and Standard.

There is an openscript that limits what the user can do. Hide status area if not admin. All records are only accessed by button selections.

Created a value list named Locked with UnLocked and Locked as their values.

Created a field named Locked and defined it as Text.

Added the Locked field to the layout.

Modified the existing find file script that uses a date picker by adding the follwoing lines:

If [Get(PrivilegeSetName) = "Standard" and Field:Locked = "Locked"

Show Custome Dialoug ("File Locked";"You do not have access to this file."

PerformScript "GoTo SomeLayout"

Exit Script

End If

So now all I have to do is change the Locked field to "Locked" after I review it and this limits it access.

I hope this may be of help to some of you.