How many users?

[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!

 

[Scott McDaniel]

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>

 

[Tony Toews]

FWIW, this is a _great_ answer.

Agreed.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm