Data Management - MS Access Upgrade
When a desktop database gets too big for MS Access.
Some of our success stories.
Learn how we met the client challenge - quality solutions, on time, on budget, to specification, and exceeding expectations - with some of our case studies.
- Data Management - Microsoft DTS to Informatica
- Data Management - Signature
- Systems Integration - USA Bank Referrals
- Project Rescue - RM Builder
- Software Development - Vicor Lockbox
- Business Process Analysis
- IT Staff Assessment
- Data Management - ARM Reports
- Quality Assurance - BYO Checking
- Data Management - Microsoft Access Upgrade
Read more
The Challenge
The Finance Division at one of our healthcare clients had several extremely large Microsoft Access 97 files that had grown too large to work with. With the addition of data from a recent acquisition, the data sets had exceeded Access thresholds and the databases were no longer functioning. Business users were performing the monthly processing with costly and inefficient manual steps. In addition, the data was not secure and was not part of the enterprise backup processes.
Our Approach
The Finance Division group felt that it was critical not to lose the local analysis capabilities they were accustomed to using for their monthly financial analysis. Therefore, we chose to move the largest data structures to Oracle, build ETL processes to load the data required by the monthly processing to Oracle, rebuild the Access SQL processes in Oracle stored procedures, and upgrade the Access databases to Access 2007.
Software Technologies
Results
By linking the upgraded Access database to Oracle, we were able to solve the problem of the size of the data without taking away the local Access analysis capabilities required by the client team. Our clients were also happy that we were able to solve their data size issues and move the critical data to a secure environment that was part of the enterprise data management processes.