Is there a limit on the number of users that can use MS Access 2007 to connect to MySQL Database
Posted on 2014-07-20
Situation: 100 users working inside an office network. Back-end database is setup in MySQL. Each user connects to this back-end with their own copy of MS Access which acts purely as a front-end user interface. MS Access links to the back-end using MySQL ODBC driver.
Known: Plans are already in the works to move away from MS Access and the MySQL back-end in favor of a MS SQL back-end and a .Net front-end user interface. We are already aware that MS Access does use more network resources in general.
Question #1: Given that each user has their own copy of MS Access 2007 and that MS Access is not acting as a database, but just a front-end...is there a user limit per se? Microsoft lists a theoretical concurrent limit of 255 users...but is this limit only applicable when MS Access is also the acting back-end? Currently, we are not experiencing any issues with the number of people using MS Access (on average, 90 copies are open and running at the same time).
Question #2: Does the MySQL ODBC driver connection to the back-end involve JET (as it is not explicitly stated anywhere in the program)?