Forum Discussion
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...
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, ...).
Thanks Daniel. Due to licence issues organisation is not allowing us to use .net and sql server. I need to figure out something with excel and access only.
- Excel is not a good choice!
Using Access for such a task is asking for problems.
Your organisation needs to be told these are the wrong tools, otherwise you are being setup for failure!
There are free tools that can be used to get around licensing, but Excel and Access are simply won't in this scenario.