How many people can update access at a time?

[Rich]

I need to find out how many people can update records at
one time in Access 2002. Also, how many people can access
the database at one time in Access 2002? Any information
re: same would be greatly appreciated.

Thanks in advance.

 

[John Vinson]

I need to find out how many people can update records at
one time in Access 2002. Also, how many people can access
the database at one time in Access 2002? Any information
re: same would be greatly appreciated.

If you look at "Specifications" in the online help you will find that
the stated limit is 255 users.

In practice, because of performance and corruption limitations, a good
rule of thumb might be 100 concurrent read-only users and twenty or so
users actively updating. This assumes a split database (*ABSOLUTELY*
obligatory at this level!), a good solid network, regular compaction
and good query and form design.