FWIW - Access 2000 CLAIMS to be able to handle 255 concurrent users. (yea, right!). But if queries is all you're doing, not a bunch of input and update stuff, then you should be fine. Dave ----- Original Message ----- From: Bud <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 01, 2000 10:09 PM Subject: Simultaneous database connections to MS Access > Hi. I know Access is supposed to break down if hit with too many > requests at once. Using Access 2000, what would be a good number to > limit the simultaneous connections to the database? I've been setting > them at 5. I don't expect there's going to major traffic at any of > the sites. A couple GB a month or so. If there are 10-20 people on > the site at once, since most queries are going to run in way under a > second, there shouldn't be but a second or 2 delay at the most, eh? > > Also, if a query is cached, does it make a connection to the DB at > all, or is it totally in RAM? > > Thanks. > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > [EMAIL PROTECTED] > http://www.twcreations.com/ > 954.721.3452 > -------------------------------------------------------------------------- ---- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
