Menu
What are the maximum concurrent connections ms-access supports?
873
Concurrent Connection: The maximum amount of simultaneous connections your server can handle.
Make sure that Access is set to open in shared mode on all of the users' computers. This is the default setting, but you should check to be sure — if a user opens the database in exclusive mode, it will interfere with data availability. Start Access and under File, click Options.
Access is well able to handle a million or 5 million records. SQL Server goes well into BILLIONS of records.
There is no max. You can put the tables in a separate accdb and link to them from your front end (which has all the forms, reports, queries etc.) There is a maximum size of 2GB for an accdb file.
In theory 255, in practice well it’s depends. If they are mostly read only and the network you are on is fast then I have seen 100+ with no problems on a well written database. On the other hand I’m sure the same old horror stories of databases getting corrupt with 2 users will come up. Yes it can happen but if you make a good database and are realistic about what you do with it you can get a surprising number of users hanging off one.
In the long term you might want to look at the free (Express) version of SQL server for higher user counts.
88
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
