Initially, the recycling company approached us to support its ailing MS Access database. On investigation we discovered that the database had not been split into two, as per MS Access best practice. Making this split — with the tables separate from the queries, forms, and reports — gave an improvement in performance, reliability, and security.
However, the database was still experiencing some corruption. The cause, we determined, was the fileshare connection used to interact with the database remotely. We addressed this issue by replacing the fileshare with a new router that supported a virtual private network (VPN). Because the VPN was stable and end-to-end encrypted, this solved the connectivity and security issues of the old fileshare.
In the short term, this solution worked perfectly — the staff now had uninterrupted access to reliable company data.
But Access also had long-term disadvantages, such as corruption, compliance issues, and lack of scalability. Our client’s management recognised this as a barrier to the company’s agility and growth.
For this reason, we proposed moving the company database to an enterprise-grade SQL Server in the Azure cloud. By keeping the Access application as the interface for the new database, we maintained the same user experience. This guaranteed full adoption and mitigated the time and cost of user training.