Harikaran,
Your are welcome. Cleanup Orphaned Logins the next day: Finally, you may need to periodically schedule ( typically during the offpeak hours ) an Asp page to loop thru the login table and Reset the login flag for all user's where the login date is > 24 hours. If you're using Sql Server you can schedule a sql server JOB to execute a store procedure to do this against the login table. Regards, Paul Chu -----Original Message----- From: Harikaran Sivakumar [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 9:02 PM To: [EMAIL PROTECTED] Subject: RE: [AspClassicAnyQuestionIsOk] active user Dear Paul, I also had the same problem. Thank you very much for your timely help. Regs, Harikaran.S Bangalore Paul Chu <[EMAIL PROTECTED]> wrote: I believe you are trying to avoid duplicate logins by the same user to the website. If a user A logs in you validate against the user/pass against the Access DB. To track and prevent duplicate login's you have to manage ans store a list of active users. You could use your Login table. You could add a login flag and login datetime to your access login table. Update these when the user log's in and reset the login flag when the user sign's out. BUT , you will have a problem determining when the user has left when the user's navigates away from your website. You may have to depend on the session_timeout handler in your global.asa This code will have to use a session("user") variable to lookup the user in your login table and then clear the login flag. This is a somewhat clumsy solution but it should give you ideas on the programming issues you face. Regards, Paul Chu -----Original Message----- From: Susetio Adhi [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 18, 2004 10:36 AM To: [EMAIL PROTECTED] Subject: [AspClassicAnyQuestionIsOk] active user Dear all ...... How to know a user is still active or not from an asp page, so i can reject user with same user name? That user name and password stored on access database. Not just count how many user online ... Thanks before -- Best regards, Susetio mailto:[EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT <http://us.ard.yahoo.com/SIG=129rq9g4m/M=298184.5285298.6392945.3001176/ D=groups/S=1705006764:HM/EXP=1092936498/A=2164330/R=0/SIG=11eamf8g4/*htt p:/www.netflix.com/Default?mqso=60183350> click here <http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group s/S=:HM/A=2164330/rand=158892875> _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] subscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service. [Non-text portions of this message have been removed] Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT <http://us.ard.yahoo.com/SIG=129ct9i8b/M=298184.5285298.6392945.3001176/ D=groups/S=1705006764:HM/EXP=1093096557/A=2319501/R=0/SIG=11tq0u909/*htt p:/www.netflix.com/Default?mqso=60185353&partid=5285298> click here <http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=group s/S=:HM/A=2319501/rand=365820719> _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] subscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
