Microsoft Access database migrations

London Borough of Enfield

Twelve Microsoft Access databases were migrated to Rapid to future-proof, secure, and avoid their complex installation by making them accessible via a browser. Some of them were more than 20 years old! Their databases were upgraded to SQL Server, and their front-ends migrated to Rapid with their security managed in Active Directory.

Most of the databases were completed within 8 months, and included Address Matching, Absence Monitoring, Child Guidance, CTS Commissioning System, Delegated Powers, Facilities Management Parking, Homefinder, Microfilm and Records, Property Enquiry Management System, Room Booking for Community House, School Placement Appeals, School Exclusion Appeals. Speeds up and improves the accuracy of back-office processes for cost saving and greater resident satisfaction.