Fog Creek Software
Discussion Board




Welcome! and rules

Joel on Software

upgrading from Access & VBA to VB.net

Hi, has anyone gone through the process of upgrading a Access (front-end forms) & VBA modules (logic) to a VB.net?

We are thinking of 1st upgrading to VB6 and then do the migration to VB.net. Any thoughts ??? Any tools that may help with this?

Craig

Craig Patrick
Tuesday, March 30, 2004

Keep in mind that VB6 and VB.Net are completely different languages -- they have a similar syntax, but that's about it.  Just upgrading from VB6 to VB.Net is a major deal.  The Upgrade Wizard might help you, but it generally results in code that's pretty ugly and unmaintanable.  You're usually better off just rewriting everything by hand.

Going Access -> VB6 -> VB.Net will be an even bigger headache.  I wouldn't count on any automated upgrades. 

These are your only real options, IMO:

1.  Do nothing.  If it ain't broke, don't fix it.  If you have any new projects, build them in VB.Net, but leave your legacy code in its original language(s).

2.  Rewrite everything by hand.  This will result in much cleaner and more maintainable code.

3.  Rewrite some of the code (e.g., the front end) to VB.Net.  Leave the rest (e.g., business logic) as a VB6 DLL, which you can use in your .Net project.  Later, if you want to, you can port the other code.

Robert Jacobson
Tuesday, March 30, 2004

Sorry, forgot that your logic was in VBA modules, not VB6.  Upgrading those to a VB6 library should be quite simple, though.

Robert Jacobson
Tuesday, March 30, 2004

*  Recent Topics

*  Fog Creek Home