Limit User from Deleting and Updating records

Question

0.00/5 (No votes)

See more:

Hi Guys,
I am using MS Access and VB.Net 2008 and I need help

1. I have Purchases and Employee Information forms with buttons (Add, Save, Update, Delete and Reload).
2. Main menu form
3. Login form.
I want to limit some privileges for the User in such a way that if the User logs in, Update and Delete buttons should be disabled so that the User is unable to Delete and Update records unless admin.

I have coded the login button in the login form as shown below. But if I logs in as User (Username: system. Password: manager) and open purchases or Employees information form, it first disable Delete and Update buttons and later they become active (not disabled) after adding another record or clicking reload button.

Below is the coding:

Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click

'Admin login
Dim admin As String
Dim administrator As String

'User login
Dim system As String
Dim manager As String

If txtadmin.Text = "" Then : MsgBox("Please input User Name", MsgBoxStyle.Exclamation) : txtadmin.Focus() : Exit Sub : End If
If txtadmin1.Text = "" Then : MsgBox("Please input Password", MsgBoxStyle.Exclamation) : txtadmin1.Focus() : Exit Sub : End If

If txtadmin.Text = "admin" And txtadmin1.Text = "administrator" Then
Me.Hide()

ElseIf txtadmin.Text = "system" And txtadmin1.Text = "manager" Then
frmPurchases.btnDelete.Enabled = False
frmPurchases.btnUpdate.Enabled = False

frmEmployessDetails.btnDelete.Enabled = False
frmEmployessDetails.btnUpdate.Enabled = False

Me.Hide()
Else
MsgBox("Sorry, Your Login Detail is invalid" & vbCrLf & vbCrLf & "Please contact the system administrator", MsgBoxStyle.Critical MsgBoxStyle.OkOnly, "Error: Username or Password Invalid")
txtadmin.Focus()

txtadmin.Clear()
txtadmin1.Clear()

End If
End Sub

Posted 3-Sep-13 0:06am

Member 9493910

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Zafar A khan · Answer 1 · 2013-09-03T00:23:00

Solution 1

C#

class security
{
 public static string role;
}
Create a column in users table [Role]
now read that role at the time of login
store it in static variable (i think shared in vb.net)
initialize like this
security.role=usertable.Row[0]["Role"];

now on any form load check it like this
form_load(object obj,eventargs sender)
{
   if(security.role=="admin")
      btnsave.Enabled=false;
}

Posted 3-Sep-13 0:23am

Zafar A khan

Comments

Member 9493910 3-Sep-13 8:15am

Hi Zafar Zafi Thank you very much. I am really not familiar with C# but if you could provide vb.net codes for this steps Thank you