How many users?

  • Thread starter Thread starter Steve Billard
  • Start date Start date
S

Steve Billard

How many concurrent users can Access 2002 support? Other
versions? I've got a director breathing down my neck
because I told him that Access was a personal database
platform and that ONE concurrent user was the maximum to
ensure data integrity. Am I wrong? If so, then how many
users can Access support before I've got to Jetpack/repair?
If it depends on the schema and the rate of transactions
is there a rule of thumb or a formula I could employ to
give this guy a "better" answer. I told him to use SQL
Server for the backend data if he needed to support
multiple users. Now I'm deep do-do. Help!
 
Access can support multiple users. According to the documentation, the
physical limit is 255. However, most people see a decline in performance
around 25 - 30 users, but many report robust performance with upwards of
100. There are no magic forumulas; every app is different and your
preformance depends entirely on your understanding of the issues associated
with Access and multiusers. Your app MUST be written with multiuser issues
in mind; a standard drag-n-drop Access app is bound to give numerous
problems. Google on "ms access multiuser" for tons of input on this issue.

Oh, and one user cannot be "concurrent" <grin>
 
I have up to about 60, but usually it is about 5 on many of my
applications with few problems. For heavy data and to avoid record locking
messages, I use batch update systems that have resolved almost all
conflicts.
 
Back
Top