0

Can I create 2 users and they have different function??
Database base using is MS Access.
For example I have "staff" and "admin".
Staff can insert,edit and delete data only.
Admin can check the total sales of the day.
Can I do that in VB.Net and can somebody give me some idea or example??

4
Contributors
3
Replies
4
Views
5 Years
Discussion Span
Last Post by ChrisPadgham
0

yes you can do this , make a user module and when a user login in prog , he have to login with his id , then you can check which functions he can perform .

Regards

0

Rather than bothering with a log in screen you may like to authenticate off the windows login

Function getUserName()
Dim wshNet as object
Dim sUser as string

set wshNet = CreateObject("WScript.Network")
sUser = wshNet.UserName
set wshNet = nothing
getUserName = sUser
End Function

you can then query a database table of usernames and privileges to determine if this user has admin rights.

Edited by ChrisPadgham: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.