Whats up guys, So I am debugging my companies program that the previous programmer has created. It is buggy and an annoyance in my life and I want to get this done as quickly as possible. Ive already fixed some bugs and published the updated version onto our server. HERE IS MY PROBLEM:
User installs app, login box pops up and prompts user to input username and password. Here is the sql code for logging in:
"SELECT EmpGroupPermissions.AppAccessWC, Employees.* FROM EmpGroupPermissions RIGHT OUTER JOIN Employees ON EmpGroupPermissions.GroupID = Employees.PrimaryGroup WHERE Username='" & Me.UsernameTextBox.Text & "' AND Password='" & Me.PasswordTextBox.Text & "'"
User tries to log in and I get this error; I will put the code for catching the sqlexception then the error I get when a user tries to log in:
Catch exc As SqlException varErrorMsg = _ "Sorry, the database server returned the following error:" & Chr(13) & _ exc.Errors(0).Message MsgBox(varErrorMsg, MsgBoxStyle.Critical) End Try
Heres the error that pops up when trying to log in:
"Sorry, the database server returned the following error: Login failed for user 'lesly'"
Now she is in the Employees table and she has access to the application through the EmpGroupPermissions table. Any help would greatly be appreciated because when I install it on my computer and try her username and password it succeeds, but when she tries it on her computer it fails, along with any other computer I try it on. Thanks in advance!