Weird LDB file behaviour

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top