Split Accesss Database

[ETID]

Any body know how many front ends are comfortable or reasonable to a single back end? And can these front ends read from the same tables simultaniously?

 

[outpatient]

I've heart 4-6 users recommended around here. Sam Greene
Workflow,DRM,DB
MUSIC

http://www.mp3.com/outpatient

 

[Newposter]

Up to 10, which is the max number of connections sharing a non-server Windows machine; and yes, they can read simultaneously. If you have more network connections allowed by a Windows server machine, you can have more simultaneous users. The network is the limiting factor, not Access.

 

[ETID]

Thanks for your input everyone,...


Newposter,.......
Any thought as to how stable it would be with say 50 users.

 

[petermeachem]

re
Up to 10, which is the max number of connections sharing a non-server Windows machine; and yes, they can read simultaneously.

Do you mean you can have 10 users on NT workstation and more on NT server.

I don't think there is actually any restriction on the number of users, just it stops working after about 10. Peter Meachem
peter@accuflight.com

 

[ETID]

Seems to me that "stops working" would qualify as a restriction eh?

 

[petermeachem]

What happens is that the more load there is, the slower the thing gets and the more frustrated the users get.
It is difficult to put any sort of precision on it, because it depends so much on the database structure, size, and what is happening. If the users are just adding names and addresses for instance, it could probably manage quite a few. Peter Meachem
peter@accuflight.com

 

[ETID]

Thanks to all