Migrate Access VBA code to VB and SQLServer

[Guest]

Hi,

I want to move an Access/VBA app to Visual Studio, VB and SQLServer. Does
anybody know how/if I can migrate the forms I developed in Access to VB in
some automated way, or do I have to recreate the forms from the beginning to
the end in Visual Studio ?

Thanks for help.
Balex

 

[Arvin Meyer [MVP]]

There are a few firms that claim that they can migrate Access to VB5 or 6,
but the only successes that I've seen involve relatively simple forms. No
one, that I know of, has attempted anything with .NET because the codebase
is so different.

Access, in my opinion, is unexcelled as a front-end to SQL-Server anyway, so
the only reasons I can think of to migrate are for use on a WAN or to
satisfy a clueless boss. Unless there are more than 50 users, or the app is
very simple, I'd use Terminal Services for your WAN because it is
significantly less expensive (even including hardware) than writing a new
app using Visual Studio.NET. I have no advice for the clueless boss problem.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Larry Linson]

I have no advice for the clueless boss problem.

Seek employment elsewhere? <GRIN>

Larry