ga***********@libero.it wrote:
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?
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