Max Users on ADODB Connection (Access)?

[D.Viddy]

How many users can access support at any one time on a website?

-Dylan
-www.codebend.net

[blindlizard]

Unless you are talking about building something like eBay, I wouldn't worry about it. The reason is that when a user requests a page, the connection is made, all querys are run, and the connection is closed. You would have to have like 200+ people requesting a page at the exact same second to notice anything strange. To have 200 people requesting at the same instant would mean you had thousands of people hitting the site in a given day. If you were building an appication for 200 users I wouldn;t worry about it. The likelyness that they would all be hitting the database at the same moment is small. However, if you were building a thick client system it would probably hold the connection the entire time the users had it open (ie all day). In this case I would not use Access.

I hope I helped answer your question and didn't confuse you more.

[D.Viddy]

That was exactly what I needed. Thanks bud.

-Dylan
-http://www.codebend.net