M
mscertified
I've been using the LDB viewer utility to check if people are still connected
to this application to determine if I can safely perform maintenance on the
database.
However, just lately, I've been noticing many users who are listed as being
logged in but logged off their PC. I've also noticed users who are listed
twice, once as logged on and one as logged off. We have users connecting via
Terminal Server and also users connecting via a web front-end. Does anyone
know if these methods of connectiong lead to normal LDB file behaviour?
Here is an example of how the web-front end connects:
Set db = CreateObject("ADODB.Connection")
db.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source='\\sstore02\helpdesk\helpdesk\CS2k3ver2_be.mdb';"
Set Rs = db.execute ("SELECT * FROM tblCSTickets WHERE TicketNo LIKE "
& strTicketNo & " ")
Set rsWeb = CreateObject("ADODB.Recordset")
rsWeb.Open Rs
If rsWeb.eof and rs.bof Then
strMessage = "Record Not Found."
MsgBox strMessage, 16, "Error!"
Document.frmmaster.TicketNo.focus()
Document.frmmaster.Get_Ticket_button.Disabled=False
db.close
Exit Sub
End If
db.close
to this application to determine if I can safely perform maintenance on the
database.
However, just lately, I've been noticing many users who are listed as being
logged in but logged off their PC. I've also noticed users who are listed
twice, once as logged on and one as logged off. We have users connecting via
Terminal Server and also users connecting via a web front-end. Does anyone
know if these methods of connectiong lead to normal LDB file behaviour?
Here is an example of how the web-front end connects:
Set db = CreateObject("ADODB.Connection")
db.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source='\\sstore02\helpdesk\helpdesk\CS2k3ver2_be.mdb';"
Set Rs = db.execute ("SELECT * FROM tblCSTickets WHERE TicketNo LIKE "
& strTicketNo & " ")
Set rsWeb = CreateObject("ADODB.Recordset")
rsWeb.Open Rs
If rsWeb.eof and rs.bof Then
strMessage = "Record Not Found."
MsgBox strMessage, 16, "Error!"
Document.frmmaster.TicketNo.focus()
Document.frmmaster.Get_Ticket_button.Disabled=False
db.close
Exit Sub
End If
db.close