Username

[Guest]

I'm using the NT user to connect to the SQL server used by my ADP project And
I would like to create profil for users inside my database so if connected as
USERX show menu1 else show menu2. Maybe there is an other way to do it in
fact I would like to hide everything so user cannot change anything in the DB
but in the mean time when I log I want to have evreything.


Thanks

FRED

 

[Guest]

fred

Capture user id . There is an adp equivalent of SQL USER_ID()

Add "AllowBypassKey Property" and make it false/true depends on the user.
Also you can give custom start up form
R.D