How many people can update access at a time?

  • Thread starter Thread starter Rich
  • Start date Start date
R

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.
 
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.
Click to expand...

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.
 
Rich said:
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.
Click to expand...

Lots, but they may bump into each other due to record locking.

Frankly if you have a lot of people (how many is a lot?) Access may not
be the right container.
 
Back
Top