# Database

**URL:** <https://forum.kirupa.com/t/database/169793>\
**Category:** Uncategorized\
**Created:** [November 19, 2005, 2:39pm UTC](https://forum.kirupa.com/t/database/169793 "2005-11-19T14:39:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kurdix](https://avatars.discourse-cdn.com/v4/letter/k/ed655f/32.png) [@Kurdix](https://forum.kirupa.com/u/Kurdix)\
**Post date:** [November 19, 2005, 2:39pm UTC](https://forum.kirupa.com/t/database/169793/1 "2005-11-19T14:39:24Z")

</div>

Hey

I want something that can count how many users that is online on my site.  
Im using ASP and i just wonder if i can use ActionScript?  
Im totallity a newbie with ActionScript and Flash, but im ready to learn.

I want the flash to connect to my database (microsoft access db) and count how many users that is online and then type it. But i want it to be refreshed every secound. If it is like 14 users online, and a users just logged in on my site i what it to type 15 directly for all users. Is it possible?

EDIT:  
Like this…

set connection = server.createObject(“adodb.connection”)  
connection.open “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” & Server.MapPath(“db.mdb”)  
onlinenow = DateAdd(“n”, -10, Now)  
SQL = “SELECT COUNT(\*) AS onlines FROM Members WHERE oc \> #” & onlinenow & “#”  
SET rs = Connection.Execute(SQL)

rs(“onlines”)