The absolute maximium number is 255. Most people find, however, that
somewhere between 30 - 50 users is the real limits. Of course, there are
Access apps out there supporting far more that that (well over 100), but in
those apps everything is dead on, and I would suspect they're not highly
transactional in nature (i.e. lot of lookups, not a lot of data entry). My
concern is not so much performance but data integrity with a database used
by that many people. Access/Jet is not unfamiliar with data corruption, and
the more people "hit" the database at the same time, the greater your
chances for corruption. Anytime my clients hit 30 users, I begin the gentle
persuasion to move up to SQL server, MySQL, etc.
--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP
"Smash forehead on keyboard to continue ... "
