Access/Visual Basic to Web Application General Question????
Posted on 2011-10-14
I have a pretty extensive Access/Visual Basic Front-End application that's approx. 11 years old with ongoing development over its life even still today. It's a tracking/reporting application that's used by the customer service department to track product deliveries and tech services performed at customer's properties in various states. The transactions are posted to the back end database (MySQL) by a satellite tracking device mounted in the driver/tech vehicles or manually by dispatch using the front-end GUI. The front-end GUI connects to a MySQL database for the main tables in the application and SQL Server to pick up the Accounting systems tables (that's where the customer account information is stored/maintained). I personally created the application plus all Visual Basic code. It is about 60% SQL and 40% Visual Basic Recordset processing, etc.
This all works great but now the client needs to give the area managers the ability to access some functionality of this app (mainly some of the reports for their respective areas) through a custom web interface. In other words, they're not interested in say a remote connection (VPN, Citrix Server, etc.). Basically they want to develop a web interface to simulate some of the functions in the Access front-end since it would be impossible to run the Access front-end in a web browser.
It would be practical to try and duplicate 11 years of development all at one time so I recommended that we take a few functions that Dispatch currently uses to produce information for the area managers and start there and get that portion working. Then expand the web interface as needed/requested duplicating what's already running in the Access front-end. Therefore, the objective right now would be ....
1.) A web interface where each area manager can log in and display certain statistical information relating to his/her area.
2.) Develop some of the essential reports (2 or 3) at the moment that's currently being run by Dispatch and emailed to each area manager.
The question is .... What web development environment/language would be best suited for this purpose???
The client already have a web server and my thinking is they will need an experienced web developer and or web development team to pull this off successfully with extensive collaboration from me because I created the existing front-end. If they are looking for a web developer ... what should they specifically be looking for relating to skills??? This is kind of a web application and not just a static / dynamic web page to display information. The reports are pretty involved and is why Access was selected in the onset because of it's graphical reporting object.
Any ideas, comments, suggestions, etc. will be appreciated.