The ASP Chat Script Problem.

Hi,
  I'd like to start a little discussion amongst ASP programmers concerning the problem of programming a decent chat program in ASP.
  Here is the basic problem I have seen in all ASP chat programs:
Enter later and the text from earlier is still there.
  My question is - Is there any way to fix this?
Here's my idea:
Have the chat program enter text into a database, one field keeps a record of all the chat text (for chat records), the other of each individual user along with a time stamp. When that individual logs out the script checks to see if anyone else is present in the room, if not it clears the text. If another person is in the room it adds a ID number of the chat text entered by the leaving individual to another person in the room...When that person leaves it checks again, if another person is present it gives all the ID numbers + that individuals to this next individual, and so on. When the last person finally leaves all the ID numbers are in that persons variable (e.g. txttowipe) and all the text is wiped.
The problem with this is - could Access handle this or only SQL? If Access couldn't - could it if the database was compacted and repaired upon the last departure of an individual?
Respectfully,
David Mackey.
- www.civilwarsearch.com

Hmmm...So, so far it is not looking very hopeful for the design of a professional ASP chat room script. Does anyone have any recommendations on how one could be made?
The traditional way of posting text to a HTML file appears to be sinking b/c if a lot of traffic were to come through bandwidth would be unreasonable because of the constant refresh rate...
The way of the database also appears to be sinking because of the fact that there can only be so many simultaneous connections to the database...
Any other recommendations?
Respectfully,
David.

I'll look into ConquerChat and get back to you. :-)

Respectfully,

David.