access rights

[Keiath]

Hi Guys

I have a complicated ordering database and I need to put in a login and access rights.

IE:- 1 person as the right to enter orders but not allocating orders
another person has the rights to allocate but not dispatch and so on

What would you guy recommend ?

 

[jdraw]

What you are describing is role based access control.
Suggest you google it to help with what's involved.

 

[DavidAtWork]

If you build your login such that users are given a user level of access, ie Allocater, Despatcher, Orderer etc then at a very simple level, you can control whether buttons that open various forms or run various functions, are enabled or disabled
David