database

Unlike traditional file-based applications, databases are flexible and built for a greater degree of collaboration.

Several users can add, modify and delete data at the same time, with changes made by one user available to all others simultaneously.

When developing a database application the choice of database engine is one of the most important decisions to make, and we have experience with many engines including Microsoft Access, Microsoft SQL Server and MySQL Server.

Microsoft Access is simple to install and maintain as it requires no additional application software, being accessed by reading and writing directly to the data files, and is most suitable for small user groups.

A database server such as Microsoft SQL Server or MySQL server is better suited to bigger user groups requiring simultaneous access.

These servers can run on the same PC as the database application or run on a separate server computer. They can restrict access to their database to just their Local Area Network (LAN) or can be configured to allow access over the internet, enabling remote offices to connect to the central database.