Where I work, we currently have an in house database system that is the heartbeat of the company. The system is written in VBA (Access) with an SQL server database. This database system is now approaching 20 years old and while it has served us well, our external developer is retiring in the not too distant future.We have approximately 250 users accessing this database across 7 countries along with various web based dashboards and a PDA system that links into this as well.
We thought this would be a great opportunity to redevelop the database into something more up to date and current for various reasons, as there have been multiple complaints over the last 6-12 months with the current system. My problem is that I have to recruit a new developer and was wondering in which direction I should be going along (potentially web based solution) and with what languages I should be recruiting for. This system is only going to grow, so need something that will last for another 20 or so years.
I realise this is a loaded question, but my knowledge of programming is pretty non-existent. So any advice would be welcome.