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?
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.
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.