Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How many users can access a database simultaneously?

3 views
Skip to first unread message

gabry....@libero.it

unread,
Jan 5, 2007, 5:10:25 AM1/5/07
to
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

Rick Brandt

unread,
Jan 5, 2007, 7:01:08 AM1/5/07
to

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


Lyle Fairfield

unread,
Jan 5, 2007, 7:14:37 AM1/5/07
to
gabry....@libero.it wrote in news:1167991825.366187.158000
@q40g2000cwq.googlegroups.com:

> Does anybody know how many simultaneous user access can MS Access 2003
> handle?

Maybe God? ...

--
lyle fairfield

Paul H

unread,
Jan 5, 2007, 7:25:39 AM1/5/07
to

>> Does anybody know how many simultaneous user access can MS Access 2003
>> handle?
>
> Maybe God? ...

Do you have his email address?

;o)


Gary Floam

unread,
Jan 5, 2007, 12:04:00 PM1/5/07
to
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....@libero.it> wrote in message
news:1167991825.3...@q40g2000cwq.googlegroups.com...

Bob Alston

unread,
Jan 5, 2007, 12:27:30 PM1/5/07
to
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

CDMAP...@fortunejames.com

unread,
Jan 5, 2007, 1:55:16 PM1/5/07
to

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
CDMAP...@FortuneJames.com

pietl...@hotmail.com

unread,
Jan 5, 2007, 3:52:20 PM1/5/07
to
> 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
> CDMAP...@FortuneJames.com

What about Ford Prefect? is he available?

Bri

unread,
Jan 11, 2007, 12:57:32 PM1/11/07
to

Wasn't Slartibartfast the PM on that project? :D

--
Bri

0 new messages