How many users can access a database simultaneously?

Hi everybody,

I am creating an application with MS Access 2003, using a workgroup
file to manage user connections. I already created several groups in
the workgroup file and assigned them to the users to define their
access-level and rights.
Does anybody know how many simultaneous user access can MS Access 2003
handle?

Thanks,

Gabo

re: How many users can access a database simultaneously?

gabry.morelli@libero.it wrote:The technical limit (totally unrealistic) is 255. A well designed app (with
respect to networking and multi-user issues) can go into the low one hundred-ish
range, but that is more likely if most are reading rather than writing and when
all other factors (the network and hardware) are ideal. A poorly designed app
will fall over on two users.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

re: How many users can access a database simultaneously?

gabry.morelli@libero.it wrote in news:1167991825.366187.158000
@q40g2000cwq.googlegroups.com:
Maybe God? ...

--
lyle fairfield

re: How many users can access a database simultaneously?

Do you have his email address?

;o)

re: How many users can access a database simultaneously?

A lot depends on how regular your network is. If there is a variation in
network latency, your capabilities are much reduces. Also, long memo fields
are particularly treacherous in a multi-user environment.



<gabry.morelli@libero.itwrote in message
news:1167991825.366187.158000@q40g2000cwq.googlegr oups.com...

re: How many users can access a database simultaneously?

Gary Floam wrote:Why not tell us how many simultaneous users you need and whether they
will be reading only or updating data and you will get a better answer.

Bob

re: How many users can access a database simultaneously?

gabry.morelli@libero.it wrote:My improbability drive CPU
spit out an answer of 42.
I'm not sure of this answer for I
am sure that Doug Adams cannot verify.

James A. Fortune
CDMAPoster@FortuneJames.com

re: How many users can access a database simultaneously?

My improbability drive CPUWhat about Ford Prefect? is he available?

re: How many users can access a database simultaneously?

pietlinden@hotmail.com wrote:Wasn't Slartibartfast the PM on that project? :D

--
Bri