Case Studies
Project Profile for the Healthcare Access Database Conversion
Executive Summary
Company
Marsh is the world’s leading insurance broker and strategic risk advisor. The company was founded in 1871 in Chicago after the Great Chicago Fire.
Solution Description
The Microsoft Access 97 application was converted to Microsoft Access 2003.
Software and Services
- Microsoft Windows XP
- Microsoft Access 2003
- Microsoft Access 1997
Customer Profile
Sector: Financial
Industry: Insurance
Revenue: $5 Billion
Marsh provides its clients the experience and resources to help navigate the global risk landscape…seeing risks others don't and unlocking opportunities others can't. The company employs approximately 40,000 people. Marsh is part of the family of Marsh & McLennan Companies (MMC).
Business Situation
The firm was using their Healthcare Access Database to manage their healthcare insurance customers and policies. The database was on the Microsoft Access 97 platform. Access 97 is outdated and has trouble functioning properly on newer PCs. Marsh needed a solution to allow them to use the system on all PCs in their offices. It was critical that the solution have a seamless implementation.
Solution
Healthcare Access Database
The experts at alligatortek offered three different solution options. The advantages and disadvantages of each solution was provided in detail and discussed. Marsh chose to have the Access 97 database converted to an Access 2003 database. The staff at alligatortek converted the database, thoroughly tested all functions of the database, and fixed all programming code that was not functional. The database was delivered to Marsh and alligatortek provided assistance in moving the data from the Access 97 database to the new Access 2003 database. This provided a seamless implementation while keeping the downtime of the database to a minimum.