We currently have business software that is run in Access 2003 with a SQL Server backend. The SQL Server database contains 82 tables which we currently have no problem with. The Access application contains 239 forms and subforms, 141 reports and subreports, 247 queries, and 25 tables which are used for temporary storage that is used to populate the forms and reports.
The main functions of this software is data entry and editting as well as reporting. Reports need to be printed, faxed (very important), and e-mailed. Our Classic ASP web page also connects to the SQL Server database and provides basic data entry and reporting functions, so long as we continue to use our SQL Server database, I see no reason to upgrade this, but if we do move to web based business software it might make sense to integrate this as well.
Since Access 2003 is long past the end of its useful life and is no longer supported by Windows 10, we obviously need to upgrade. Rather than upgrade to Access 2016, I would like to upgrade to a more sustainable form, whether that be Visual Studio .NET or ASP.NET, I would like some advice on which option would make more sense. Regardless of which path we choose, I would like it to be done in Visual Basic so that I would be able to maintain it going forward.
It took me a little over a year working part time to create the software, before that the software used GWBasic run on DOS, which included developing the database and importing the GWBasic storage files.