Last post Aug 20, 2018 07:41 AM by Nan Yu
Aug 16, 2018 05:04 AM|Manimaran R|LINK
We have an application in MS Access 2010 (ADP format) which contains Module, Class Module, Crystal Report and connecting with SQL Server for back end. We got the requirement to migrate the application to Visual Studio .Net Framework (v 4.6) - VB.Net language.
As far i know Forms and Crystal reports should be re-created, and VBA & VB.Net both are two different languages but there are some code (Module / Class Module) can be converted into .Net. I am going through various technical forms, but couldn't find the
right flexible tool / online conversion / suggestion for this.
Tool to convert .bas & .cls file coding to VB.Net
(or) Import .bas & .cls file to Visual Studio .Net (Don't want to refer the .bas/.cls file, instead of again want to convert to vb.net by importing the code of the file)
(or) Online conversation of .bas & .cls coding to VB.Net
Please help & advise me. Also give your suggestion on the migration.
Aug 17, 2018 05:19 AM|Nan Yu|LINK
Hi Manimaran ,
AFAIK , there is no such effective tool to to convert such files exported from Access. Consider rewriting as an alternative , this makes less work than relying on tools or migration wizard and modify the drawback .
Aug 17, 2018 05:32 AM|Manimaran R|LINK
Thanks Nan Yn.
While considering the rewrite, is there any easiest option to reuse some code from VBA?
For example VBA code contains .cls and .bas files for Form Events, Database Connections and Business Login Functions. I hope that VB.Net still can understand some piece of code from VBA like some business logic functions. If so, then is there any easiest
option and best practice to reuse some piece of code from VBA?
Aug 20, 2018 07:41 AM|Nan Yu|LINK
I am not the VBA/VB.NET expert , in my opinion ,i'd prefer rewriting which may meet less problems than converting codes.