Member Avatar for reds8

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
  • 281 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by ChrisPadgham
Member Avatar for M.Waqas Aslam

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

Member Avatar for ChrisPadgham

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 because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.