 Schematic of conversion | The Challenge
Convert a Microsoft Access application, which is used by several hospitals, to a single, server-based application, which can also be used off-line
The Approach- Defined security framework, to keep patient data separate by hospital
- Defined database conversion strategy
- Defined program conversion rules
- Converted data and software, incorporating security
- Used ClickOnce for easy SmartClient deployment onto individual workstations
- Built database sychronization between SQLServer databases, using change tracking
The ResultA system that is - Secure, with user authentication
- Easily expandable to add other MS Access applications
- New, with an attractive look and feel
- Enhanced with improved data validation rules
- Secure with data through central backups
- Easy to deploy with software upgrades
- Using .Net to handle proliferation of upgrades onto workstations
|
