Welcome to WebmasterWorld Guest from 126.96.36.199
Forum Moderators: open
Problem is, a friend who says he knows what he's talking about tells me that an Access database won't handle much traffic at all.
Is that true? Just how much traffic can it handle? How many different users at the same time?
And are there any other problems anybody has experienced using this functionality?
I see from the table that the maximum concurrent users is listed as 255. That would be acceptable for a site built for a relatively small organization, such as I'm thinking about.
You said that you had thrown a lot of concurrent users at an Access db. You were talking about a web-based db, weren't you?
And the maximum concurent user limit brings up more questions:
a) What happens when the site gets overloaded? I don't know databases but I assume what we're talking about here is essentially a denial of service effect. Will the database just lock up or will the whole site crash?
b) If that site is a virtual host on a shared server, will that crash the other virtual hosts?
The database wil typically stop responding. It might become corrupt. It might stop the server, depends on the server, etc.
Usually though, if your site is this busy, it does warrant SQL hosting