Hi,

I have made a small login system, where Users can upload their files.And administrator can Download the files uploaded by users.

I have used Access as Database.

I am getting the following Error :

System.Data.OleDb.OleDbException: System resource exceeded.

Following is the code for my Login Page :-

If LoginName.Text.ToLower = "administrator" Then
Dim str, ps As String
str = "Select Password from Faculty_Login Where UserName='administrator'"
conn.Open()
Dim comm As New OleDbCommand(str, conn)

ps = Convert.ToString(comm.ExecuteScalar)
conn.Close()

If Password.Text = ps Then
Session("login") = "Yes"
Response.Redirect("AdminActive.aspx")
Else
Msg.Text = "Incorrect Login Name or Password."
End If
Else

If UserCheck(LoginName.Text, Password.Text) Then
' User Available
' do your coding
Session("login") = "Yes"
Response.Redirect("FacActive.aspx?un=" + LoginName.Text)
Else
' User Not Available
' do your coding
Msg.Text = "Incorrect Login Name or Password."
End If
End If


How to solve this error?

Thank You....!!