I'm using an SQL Server backend for a system that will potentially have 100-300 users accessing it simultaneously on a devoted server (around 50-80 tables). We are considering the accessing it through our citrix server, or using our intranet. What is the best frontend for this system? I'm considering VB.Net, as I'm familiar with it, although I'm open to whatever will work best. I had considered a MS Access frontend simply for the speed with which I could complete the project. I also need to consider the reporting service that will be used for it and I have little experience in this area (just extensive MS Access reporting). Any input/advice is greatly appreciated.
