Capacity?

[Jill]

Does someone know the limitations around MS Access. Number of users?
Number of tables? Size? Thanks. Jill

 

[Ken Snell [MVP]]

For many of your questions, type Specification into the search help box.

 

[Rick B]

Have you done a search (either here or in help)?

Rick B

 

[Jill]

Thanks!
I haven't had luck with over 5 concurrent users. I was surprised to see
255. Might be a network limitation vs application. Jill

 

[Jill]

Thank you.

Have you done a search (either here or in help)?

Rick B

 

[Ken Snell [MVP]]

ACCESS will easily handle 25 users (255 may be pushing it).

Are you using split front end and back end? Does each user have his/her own
copy of the front end?

--

Ken Snell
<MS ACCESS MVP>

 

[Jill]

I don't know what you mean by split front and back end? It will be a shared
database where seven different geographical locations (about 50 users) will
manage issues in a single repository. J

 

[Ken Snell [MVP]]

See these articles for more info about splitting a database:

http://www.granite.ab.ca/access/splitapp/index.htm

http://members.iinet.net.au/~allenbrowne/ser-01.html


How will the users be accessing the database? LAN? WAN? Internet?
--

Ken Snell
<MS ACCESS MVP>