Microsoft Access, for many organisations, can be extremely powerful and is often the first solution implemented as a method of automation and adding structure to the business. However, as the organisation grows and the requirements become more complex, Microsoft Access databases can often start to "creak" and can experience speed or data corruption issues.

What are the limitations of Microsoft Access databases?

  • They do not lend themselves well to multi-office environments
  • They have a recommended size limit which, when reached, can start to impact on performance
  • They cannot be accessed from other locations unless you install the user application

How can we help?

We have helped a number of organisations "upsize" their Microsoft Access database to Microsoft SQL (Access's big brother), whilst re-developing the user interface in a web based environment. This provides a far more flexible method of working with the database, and provides a stronger foundation for future growth.

If you have a Microsoft Access based system and are experiencing some of the issues outlined above, please do contact us on 01634 299800 to discuss how we can help.

Related case study

Enterprise Management System

CC Cousins

Medway, Kent

Facilities Management

Overview

Cousins are a dynamic organisation providing reactive and scheduled facilities management services to blue-chip clients. The nature of their business demands reliable and efficient systems that can manage their processes, and that reflect their ISO9001 procedures.

They have experienced rapid growth over the last 10 years which lead them to implement databases to address specific processes. However, these databases were all separate and shared no common data.

Our remit was to integrate these systems and consolidate data, whilst at the same time develop new functionality.

Database design, build and integration

ASP.net, VB, MS SQL