Technical bits
Delian systems specialise in the development of Microsoft Access databases with each user having a copy of the “Front end” system that links to the shared back end data that will either be another Access database or SQL Server.

Most installations are using either Access 2003 or Access 2007.

One measure of the scope of the systems can reflected in the count of objects within the database.

System	Tables	Forms	Reports	Modules
CIPTS	128	402	126	26
PowerPro	37	134	42	11
TAPTS	41	104	17	12
SPRINT	21	66	7	12

This however does not distinguish between the size and complexity of each object where there are very wide variances.

Minimal use is made of either queries or macros. Most queries are built into the code of the forms and reports that require them and AutoExec is the only macro normally used.

Most forms are unbound to eliminate the locking overheads whilst data is being either entered or changed. A locking routine is built into the detailed data forms to avoid any clash between two users seeking to update the same record at the same time. This approach enables a large number of users to work on the database concurrently.