Number of users

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

Does anyone know how many users can have simultaneous
access to Access97? I thought it was 255 but my friends
in the know (supposedly) say 10 max for updates. HELP!!
 
255 is the technical limit, but the practical limit is lower. There is not
a hard limit . It depends on how well your application is written, what
tables are being hit, locking scheme, etc.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
I'm interested in this as well.

What is the consensus on the practical limit of users?
Click to expand...

The rule of thumb that I've heard is that between twenty and thirty
users is about a practical limit if they're all updating the tables. A
split database is ESSENTIAL, as well as good form and query design to
reach this limit.

If most or all users are only reading data, not updating it, then over
a hundred should be fine.
 
Back
Top