Case Studies
Project Profile for the Repairing a Corrupt Access Database
Executive Summary
Company
The Chicago based company has been in business since 1995.
Solution Description
Their database used to get corrupted every month. Since being fixed over 12 months ago, it has not become corrupted once.
Software and Services
- Microsoft Access 2003
- Windows Scheduler
- Microsoft Windows XP
Customer Profile
Sector: Construction
Industry: Concrete Pumping Services
Revenue: approximately $1 million
The concrete pumping company is a full service provider of concrete pumping services for the construction industry. The company has longest reaching concrete pump in the Chicagoland area.
Business Situation
The company has an Access database that is used to manage their customers. For reasons unknown to the company their database was getting corrupted once a month. Every time the database became corrupted they would have to revert back to an old copy of the database. This meant they were losing critical customer information.
The company needed their Access database fixed so that it would not continue to get corrupted.
Solution
Updated Database Architecture
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.
Automated Job to Reorganize the System
The database was being accessed by multiple users. This causes the database size to grow because Access accumulates temporary data for each user. A nightly automated job was setup to reorganize the database. This cleans up all the temporary data and shrinks the database size.
No More Corruption
Since the architecture and automated job were setup over a year ago, the database has not been corrupted once. The company can now continue to operate without losing critical customer data.