Martin I support Nilesh's advice...
This is usualy how we control users access to the application.
In all the cases you have to create a "Users" table and "UsersRights" table to give rights and keep record about how should access your application and what screen/fields/reports he/she can access/change/see, all to be controled from your application.
HTH
ADSC
>Hi All!!!
>
>Straight to the point! Using VB how do I determin the rights of a particular account in SQL? I'd like to be able to disable buttons on my VB program if a user a particular user does not have sufficient rights.
>
>That's All :)
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>