Upgrading from VBA program to Vb.Net - also upgrading to sql server - asp.net or vb.net?
Posted on 2006-07-04
i currently have designed a VBA program that is very comprehensive and we are thinking of trying to sell it commercially.
Since the program is currently a VBA frontend linked to an Access database, I am thinking of upgrading the sytem to Vb.net and using sql server database.
I am wondering will I have to Start from scratch in design process, or is there a quick way around this i.e upgrade tools?
I also am wondering about the Reports, they are currently designed in Access, im sure there not compatible with sql server?
This is probablly a complex task that lies ahead, but it should be worth while, I was advised maybe to look at using asp.net as the frontend, instead of vb.net? is this advisable?
Hope someone can give me some advise?