Hello, I have been working with global.asa and have tried to make an online users table out of my user database, I have worked with some people that really know their ASP but I have not been able to get it working PERFECTLY. Here is what I got so far and here are my problems/concerns:<BR><BR>1. I have been told it really bogs down the server if you do Database access in global.asa so is there any way around this?<BR><BR>2. In this current version it will show the number of guests fine but it does not seem to me setting "Loggedin=off" for users when they leave the site.<BR><BR>Here&#039;s the code:<BR><BR>&#060;script language="vbscript" runat="server"&#062; <BR><BR>Dim objConn, ConnString <BR>Dim struser<BR><BR>ConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=D:inetpubmysitemydb.mdb" & ";"<BR><BR>Set objConn = CreateObject("ADODB.Connection")<BR>Set objRecordset = CreateObject("ADODB.Recordset")<BR>objConn.Open ConnString <BR><BR>Sub Application_OnStart<BR>Application("visitors")=0 <BR>Application("guests")=0<BR>End Sub <BR><BR>Sub Session_OnStart<BR> <BR>struser = Request.Cookies("GamingWorld")("username") <BR>Session("username") = struser <BR>if struser="" then <BR>Application.Lock <BR>Application("guests") = Application("guests") + 1<BR>Application.UnLock <BR>else <BR>objRecordset.open "Update members set LoggedIn=&#039;on&#039; where username=&#039;" & struser & "&#039;", objConn <BR>Set objRecordset = Nothing<BR>end if <BR><BR>End Sub<BR><BR>Sub Session_OnEnd<BR> <BR>struser = Session("username")<BR>if struser="" then <BR>Application.Lock <BR>Application("guests") = Application("guests") - 1 <BR>Application.UnLock <BR>else <BR>objRecordset.open "Update members set LoggedIn=&#039;off&#039; where username=&#039;" & struser & "&#039;", objConn <BR>Set objRecordset = Nothing<BR>end if <BR><BR>End Sub <BR><BR>Sub Application_OnEnd<BR>objConn.close<BR>objRecordSet .close <BR>Set objConn = Nothing<BR>Set objRecordset = Nothing<BR>End Sub <BR><BR><BR>&#060;/script&#062;