Maximum Access Users

[shamas21]

Hi All

I know that Access probably permits around 20 or so users to simultaneously access the database before it start to become unfriendly.

However, I have a database that would require 200 or so users grabbing around 1,000 rows of data via an Excel ADO connection to the backend tables.

So they would never need to physically go inside the Access database its self, but instead it would garb data by opening an ADO connection to the database > Grabbing the data > Closing the database connection.

Is this okay to do with around 200 users simultaneously querying the database tables via an Excel ADO connection?

Thanks

 

[pr2-eugin]

Hello shamas21, based on the Documentation - Access can provide support upto 255 concurrent users.. Is that in reality True/False I do not know. The maximum users I have in my apps never gone past 23..

However I do not understand why you would like to have Excel connection.. Explain this scenario of having an ADODB connection. Remember having a Persistent connection will improve the speed and efficiency of Data retrieval. If you open and close connection when and where required it might feel even slower.