473,320 Members | 1,859 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to convert Access to VB Dot Net

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
3 12905
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Mich | last post by:
I'm going crazy trying to convert an Access Function to SQL. From what I've read, it has to be done as a stored procedure. I'm trying to take a field that is "minutes.seconds" and convert it to...
12
by: Guy | last post by:
I got a big Access file (1 400 tables) to convert to SQL and I would like to be provided with some automated tools, except upsizing wizard and DTS, to convert it on my own. I got a lot of forms...
1
by: Gary Dale | last post by:
I have a database that was originally set up in Access 97 (because that was what we had in the office). We had a copy of Access 2000 set up on one machine for a brief period to get at another...
3
by: Derek Riley | last post by:
I have been using Access97 for some time now and decided to upgrade to 2000, the problem is when I convert it to 2000 I get the following message "There were compilation errors during the...
1
by: Collegue | last post by:
Is it possibly to convert access database into other program like C++ or Delphy. Thanks
3
by: Nigel C | last post by:
I have been tasked with converting a legacy Access 2 system to Access 2000. This in itself is not the issue. I have a copy of the Program, Data and SYSTEM.MDA file used by the client. However, I...
8
by: s_wadhwa | last post by:
SELECT DISTINCTROW "01C" AS dummy, Buildings.BuildingNumber, UCASE(Buildings.BuildingName) AS BuildingName, Buildings.MasterPlanCode, Buildings.UniformBuildingCode,...
1
by: Parasyke | last post by:
Thanks in advance. I'm new to XML. I need to convert an existing Access table into XML which will allow me on a form to read the table into XML, edit, then reconvert it back to the Access table. I...
2
by: MrDeej | last post by:
Hello my good people! We have developed an application on the Access plattform for the last 3 years. Now we see that it has grown to a size where we would like to convert to standalone program...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.