By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

How many users can access a database simultaneously?

P: n/a
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

Jan 5 '07 #1
Share this Question
Share on Google+
8 Replies


P: n/a
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
Jan 5 '07 #2

P: n/a
ga***********@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
Jan 5 '07 #3

P: n/a
>Does anybody know how many simultaneous user access can MS Access 2003
handle?

Maybe God? ...
Do you have his email address?

;o)
Jan 5 '07 #4

P: n/a
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.

<ga***********@libero.itwrote in message
news:11**********************@q40g2000cwq.googlegr oups.com...
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

Jan 5 '07 #5

P: n/a
Gary Floam wrote:
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.

<ga***********@libero.itwrote in message
news:11**********************@q40g2000cwq.googlegr oups.com...
>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

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
Jan 5 '07 #6

P: n/a
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?

Thanks,

Gabo
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
CD********@FortuneJames.com

Jan 5 '07 #7

P: n/a
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
CD********@FortuneJames.com
What about Ford Prefect? is he available?

Jan 5 '07 #8

P: n/a
Bri

pi********@hotmail.com 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
CD********@FortuneJames.com


What about Ford Prefect? is he available?
Wasn't Slartibartfast the PM on that project? :D

--
Bri

Jan 11 '07 #9

This discussion thread is closed

Replies have been disabled for this discussion.