By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,333 Members | 1,022 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,333 IT Pros & Developers. It's quick & easy.

How to convert Access to VB Dot Net

P: n/a
What tools are available to convert Access projects (Forms, Code, Queries,
Reports) to VB Dot Net?

Does anyone have experience with this type of conversion? Please tell me I
don't have to do it by hand!
Thanks,

Bill
Cincinnati, OH USA

Nov 20 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
AKAIK there are no such tools, for forms but you might find some code
converters if you search, likwise, there ( might ) be some report converters
to crystal.


"Bill Nicholson" <us****@nicholsoncomputerconsulting.com> wrote in message
news:Cb*************@fe37.usenetserver.com...
What tools are available to convert Access projects (Forms, Code, Queries,
Reports) to VB Dot Net?

Does anyone have experience with this type of conversion? Please tell me I
don't have to do it by hand!
Thanks,

Bill
Cincinnati, OH USA

Nov 20 '05 #2

P: n/a
I don't have any personal experience with converting Access to .Net, but I
have heard of a commercial product called "Evolution" from
www.evolutionsoft.co.uk From reports, it seems to do a better job of
converting Access than MS' own VB6->Net converter (which is totally useless,
IMO).

As with any converter, YMMV as to how well it works. Some projects may
convert without a hiccup, others will result in a God-awful mess that you
could end up spending more time trying to fix than if you started over from
scratch. I would be particularly concerned about reports, macros, and
concurrent database access. If your Access app was designed as a multiuser
solution, you should be prepared to perform extensive stress testing to make
sure the converted app works the same way if its database operations do
translate to ADO.Net at all. Most conversions that I've come across tend to
just wrap the existing data access code with the .Net adodb component, or
simply invoke the legacy COM components directly. ADO.Net is strictly
disconnected, having no realtime access to the database, whereas in ADO or
its predecessors, you could work "live" with recordsets and tables. The
handling of concurrency can have subtle, yet dramatic consequences for an
application.

Frankly, my recommendation is that you take a serious look at the
application(s) you want to convert and determine if you wouldn't be better
off redesigning them from the ground-up for the .Net world. While you can
convert a good number of existing apps, there are many new capabilities and
techniques in .Net that can greatly simplify how things are done, or enable
you to do things you couldn't before. Simply translating old VB code won't
necessarily give you any of the real benefits of the new technology and, as
I said, you could wind up spending more time cleaning up. If you do explore
the converter route, approach it with few expectations for better than 40%
success, and realize you still may have to do considerable work to get what
you are hoping for out of it.

Alan
"Bill Nicholson" <us****@nicholsoncomputerconsulting.com> wrote in message
news:Cb*************@fe37.usenetserver.com...
What tools are available to convert Access projects (Forms, Code, Queries,
Reports) to VB Dot Net?

Does anyone have experience with this type of conversion? Please tell me I
don't have to do it by hand!
Thanks,

Bill
Cincinnati, OH USA

Nov 20 '05 #3

P: n/a
On Wed, 28 Jul 2004 07:38:20 -0400, "Bill Nicholson" <us****@nicholsoncomputerconsulting.com> wrote:

What tools are available to convert Access projects (Forms, Code, Queries,
Reports) to VB Dot Net?

Does anyone have experience with this type of conversion? Please tell me I
don't have to do it by hand!


Don't know much about the product but ran across it during a previous search:

http://www.microtools.us/
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.