In the technical documents, it states that a possible max of 255 users can
connect to the database.
However, in actual practices, you will not get near that many users.
The number of users will depend on MANY factors. (what kind of network
connection, how large the tables are, how many users are just looking at
data vs how many are updating).
If your tables are small, say only 75,000 to 150,000 records in size, and
you only got 10 users, then you should be just fine.
As user counts in increase when using a JET file share, then so does the
risk of damage to the file share.
However, with ms-access you can choose data database (data store) you use.
So, ms-access is only a tool to make forms, write code etc, and the limits
of the number of users is going to dependent on the data engine you use with
ms-access.
There are some companies right now with 1000 SIMULTANEOUS users all at the
same time!! Of course, they used ms-access for the front end, and for the
database part, they used sql server. So, depending on what data engine you
use to store data, in fact you can have more then 255 users. So, if you
want, you can write your application in ms-access, but the data can reside
in a oracle database.
