Restructured Architecture – A Concrete Pumping Company

Industry: Construction
Solution: Restructured Architecture
Technologies: Microsoft Access
Solution Type: Technical Support; Database Architecture Services

CPC logo
The concrete pumping company is a Chicago based company that has been in business since 1995. They are a full service provider of concrete pumping services for the construction industry with a revenue of approximately $1 million. The company has the longest reaching concrete pump in the Chicagoland area.

Challenge Challenge - Mountain without Flag

The company has an Access database that is used to manage their customers. For reasons unknown to the company their database was being corrupted once a month. Every time the database became corrupted they would have to revert to an old copy of the database, and thus they were losing critical customer information. It was imperative to fix the Access database so that it would not continue to get corrupted.

Solution Solution - Mountain with Flag

Restructured Architecture and Automated Cleanup
The database was originally setup to work in a single user environment. The company had multiple people connecting to and using the database. The architecture of the database was updated to work in a multi-user environment. Since the database was being accessed by multiple users it was causing the database size to grow because Access accumulates temporary data for each user. A nightly automated job was setup to re-organize the database. The process cleans up all the temporary data and shrinks the database size. Several years have passed since alligatortek set up the architecture and automated job, and the database has not once been corrupted. The company can now continue to operate without losing critical customer data.

latest news


How to Use ADFS to Implement Single Sign-On for an ASP.NET MVC Application

Without using any complex code logic, I leveraged Microsoft’s Single Sign-On (SSO) on my existing ASP.NET MVC web application.


10 Ways to Save Money By Hosting On Microsoft Azure

Many companies move to the Cloud to lower costs and offload the management of their IT infrastructure. Once you create resources in the Cloud, there is still more work to do. By considering the list below, you can ensure you are getting the performance you need while keeping your monthly spend in check.


Is AI Making Me Lazy?

Over the course of the last month, I logged the different ways my family used AI-powered devices in my home. Does artificial intelligence mean I can't think for myself? Read what I think in my latest blog – Nate Pave.

Copyright © 2018 alligatortek. All rights reserved.