How to conform, consolidate, migrate, and modernize seven Microsoft Access database applications into a single, robust solution.
Goal: Shift from business silos (IT resources split between San Francisco and Los Angeles) to a shared services model decreasing the number of platforms supported and IT costs.
Tasks: Upgrade all MS Access applications and databases to the latest version of MS Access. Move front-end applications and back-end database to a centralized server with remote desktop.
Results: As a result of our MS Access developers, coordination of the application and database moves within the organization is a risk. The centralized server removes network bottlenecks, and the organization gets a quick application performance boost across all applications, as well as, more reliable backups and some added security features.