Navigaton and super user

[DevAccess]

Hello

I have two sets of users supers user and user supers users are with admin defined in the master table with password as "admin" and normal users are defined as "users" in master table.

Now what I would like to do is when database opens I dont want normal users click anywhere except modal form which popups in front of user.

but super can go to table and navigation and other stuff if they want to do so.

I dont want this functionality enable for normal user as well even if they click on SHIFT key when database opens.

Can anybody pleaes help me on this.

Thanks

 

[boerbende]

- Open the modal form for everyone, but make objects visible (for ex. buttons) for admin. THis can be done for example by extracting user and host from the system

********
dim username as string
dim hostname as string and serching for the userpermissions in your table
UserName = Environ$("username")
Hostname = Environ$("Computername")
********

- Search for the Function ap_DisableShift() on the internet and apply this in the intermediate window
(DON'T FORGET TO MAKE A COPY OF YOUR DATABASE FOR FURTHER DEVELOPMENT)