There may be occasions when the usage of an Access application moves beyond the capabilities of the Access JET database engine. This might particularly be the case if the application is to be used by a high number of concurrent users and can happen when a business is expanding or when the initial specification requires such usage to be included.

In such cases our solution is to use Access for all of the ‘front-end’ functionality and the mySQL open source database for the back end data. Such a combination overcomes all concurrent usage issues whilst not adding significantly to the project cost. As an alternative the SQL Server database could be used instead of mySQL although as SQL Server is proprietary software this would add significant cost to the project.

If you would like to know more about how Access and mySQL can be used together please contact us and we would be happy to tell you more.