Retricted entry by users

[akar33]

Is there any way a group of users can be blocked from modifying few fields NOT the entire records just few fileds.

Let me know.
Annie

 

[CautionMP]

Absolutely, but not with a built in mechanism. Here are the pieces.

You can change the [tt]Visible()[/tt], [tt]Locked()[/tt] and [tt]Enabled()[/tt] properties of a control at run time to disable it for certain users.

You can get the user name (LAN ID) when a form/database opens by using [tt]ENVRON("USERNAME")[/tt].

In combination you can dynamically change the form(s) at runtime to restrict what users can see or change. It's not hard but it is a bit of 'busy' work to setup.

You can also combine this with a Permissions table if you have only a couple of user roles (say Administrator, Manager, User). This way you can account for changing staff without having to change the code in your form(s).

Clear as mud?
CMP

Funny thing about being unemployed, weekends don't mean quite so much, just means you get to hang out with your working friends. Primus