Access

[Renoyl]

Hi,
Does anyone know how many concurrent users an access database can handle? With or wothout write capability.

Thanks!

 

[iqof188]

I am afraid I can't give you any numbers, but if you have a medium traffic or high traffgic website, you will definitely need another DB system. Even Microsoft warns about using Access as a dabatase for webapplications. Remember that Access was designed for desktop tasks. I've heard that Access2000 is better, but still this won't do for serious database activity on websites. Hope this helps...


<webguru>iqof188</webguru>

 

[GunJack]

I seem to remember hearing you could have around 40-45 simultaneous users on Access before you run into problems. I don't know how accurate it is but just something I seem to remember hearing.

GJ

 

[ChiefJoseph]

I think Iqof188 is right about 2000. The reasoning is the switch to OLEDB

 

[AMayer]

At my last company we had an application (not web) where some customers had 120 users almost constantly reading an Access 97 database. Access seems to hold up pretty well where just reading is going on. We had problems where two of us entering information into the same database would corrupt it in short order. If you want to use Access I'd say it's not advisable but may work unless you're allowing your visitors to submit forms or other data to it. I don't have extensive experience with Access 2000 but I doubt it's that much more stable. Andrew