Access Database Revamp – Temporary Specialized Labor Company

Industry: Staffing; Business Services
Solution: Access Database Revamp
Technologies: Microsoft Access
Solution Type: Database Recovery Services

temporary specialized labour company logo
The company based out of the north side of Chicago has been in business since 1997. The temporary specialized labor company provides supervisors, servers, bartenders, and culinary staff for corporate and social catered events, private parties, and trade shows.

Challenge Challenge - Mountain without Flag

The company uses an Access database to manage their most critical data which is clients, jobs, invoicing, and team members for hire. The database is at the heart of their operations and used by most company staff.
There were 2 separate incidents where the database became corrupted:
Corruption Incident #1
Database users were unable to access screens and reports that had information related to jobs.
Corruption Incident #2
Database users were unable to use any database functionality. They were completely locked out of the system and its data.

Solution Solution - Mountain with Flag

Corruption Incident #1
After investigating the issue it was found that data in one of the data tables that holds job information was corrupt. Experienced Microsoft Access programmers from Alligatortek found the issue and cleared up the corrupt data. The business was back up and running in a short period of time.
Corruption Incident #2
After investigating a second corruption issue it was found that a few months of job data had been corrupted. alligatortek sorted out and cleaned the corrupt data. Once the corrupt data was cleaned out several of the screens and reports had to be rebuilt because of corruption issues.
Speed and Efficiency
Both times their database became corrupted it was in the middle of their busy season. Alligatortek responded to both the corruption issues immediately and resolved the problems in as short of a time frame as possible.

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.