VBA to VB

[JulieH]

I have inherited an Access 2003 VBA app and tasked with making it run
without Access (or the runtime). My guess is that this will take some
considerable effort, but I'd like some advice as to how best to proceed. I
know of no tools to help me convert this to a straight VB app, but I'm very
new at VBA and know very little about it.
Is there, for instance, some way to export VBA forms to VB?
Anything else?
I'll be doing this development under VS2008.
I'd appreciate any help.

 

[Norman Yuan]

When you save VB, most people understand it as VB6 or older, which has more
"similarities" to VBA code in Access (even so, there isn't a tool that is
good enough to convert MS Access to a VB6 application, IMO). If it is
VB2002/3/5/8, than most the similarities are gone except for the syntex
looking alike. So, no, there is no pratically usable tool to convert/export
VBA code/design in MS Access to a .NET program (developed with VB2005/8, or
C#). The only reliable converter is a programmer who understands the said MS
Access application and .NET well.

 

[Tony Toews [MVP]]

I have inherited an Access 2003 VBA app and tasked with making it run
without Access (or the runtime).

Dare I ask why?

Various comments have been that creating a database app in another
environment can take 2 or 5 times as long.

My guess is that this will take some
considerable effort, but I'd like some advice as to how best to proceed. I
know of no tools to help me convert this to a straight VB app, but I'm very
new at VBA and know very little about it.
Is there, for instance, some way to export VBA forms to VB?
Anything else?
I'll be doing this development under VS2008.

One such tool recently mentioned is
http://www.microtools.us/default.htm. Otherwise see the Convert
Access to Visual Basic, Delphi, Java, ASP or ASP.NET page at
http://www.granite.ab.ca/access/accesstovb.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/