Forum Discussion
sunilchy
Nov 20, 2020Copper Contributor
Number of simultaneous users allowed to access database
Hi All, So far I have designed access applications for less tha 20 users. Now I have a requirement to develop something wherein users are around 130. I am thinking to develop front end using excel and...
Nov 20, 2020
Theoretically, Access can have 255 simultaneous users. The reality is quite different and depends on a multitude of factor, network, server, ... Typically, we'd say a maximum of 40 is pushing things. I have a db with 80 or so users and I know of developers who have broken the 100 users, but they are the very rare exception. With the numbers you mention of be turning to an alternate rdms (SQL server, Azure, MySQL, ...) And wouldn't even consider Access. I also would never create an interface using Excel! Use Access for the interface, or web technologies (PHP, .net, ...).