Page 2 - Im Writing a Telnet Server - Access is so tempting!

Yeah I’m about 1/5th the way through making the change. The main server application has been updated, as have one of the ActiveX DLLs. But I need to update about 3 more DLLs, each of which have around 6 very lengthy classes in them :-/.

I chose a Database over the text/INI files, purely because a Relational Database has so much more advantages over a flat file system - plus I gain the advantage of SQL - because before when I needed to 'filter out' data, I would have had to use large Do Whiles and If Thens - but now ADO just does it for me (or whoever it is that processes SQL statements)!

I used my telnet flooder that I wrote (I wrote it to test my telnet server with) and it handles fine under 200 simultaneous connections (all of which flood data to the server). If anything it was actually faster - because there are now less Do Whiles in the code (because I can use SQL) so it runs real smooth with much less over-heads. I think I may even max the connection limit up to 500 - and see how that handles (at the moment the connection limit is 200).

you better check the stability of Access under so much simultaneous connections,
you might get weird problems when it locks itself up and you try to read.