Access to Visual Basic Conversion???

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Brian (anonymous_at_discussions.microsoft.com)
Date: 10/19/04 

Date: Tue, 19 Oct 2004 08:24:09 -0700

I have spent the better part of the last 3 years writing a
relatively complicated MRP system in MS Access.
Currently, I am using Access 2003, but the database is
saved in Access 2000 format. This database consists of an
Access front end with 33 queries, 101 forms, 51 reports,
and 24 modules using an Access back end with 49 tables.
If I printed all the VB code behind the forms and reports,
it's almost 2,400 pages in a Word document with almost
100,000 lines. I write this so you can imagine the scope
and size of this database.

I am now at the point where I am starting a project to
convert the front end to Visual Basic and the back end to
SQL. And thus, my question. Does anyone know of a
translation package to convert the front end to VB.NET?

I spent some time looking into this an had decided on
AccessToVB from Greenwich Financial Modeling
(www.gfminc.com), but found that the company is apparently
out of business as all e-mail is returned undeliverable
and the phone number is disconnected. So I was hoping
that someone out there might have had this problem before
and knew of software to do this. Needless to say,
rewriting the whole thing from scratch would be incredibly
time consuming.

Thanks in advance to anyone that can help with this!

Relevant Pages

  • Re: Crystal Report Database Change
    ... Maybe this code can help you, I use it to run my reports on different db's ... > They point to my database as HQ which is called "Thom". ... They have a database server there called "Sidney" which had a ... > database settings which would be very time consuming as I will be using ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Creating Forms is tedious
    ... wished the original writer had spent a lot less time making the ... but forms and other database objects ... >that appear sloppy often are sloppy. ... >wizards, and other fluff, and so have made it far more ...
    (microsoft.public.access.forms)
  • Re: New Intel logos
    ... >>>They could've spent the money on something more practical like ... > participants were whisked into the meetings by private/chartered jets. ... think that mangement will cut their jobs? ... glowing reports, and business trends of the consumer. ...
    (comp.sys.ibm.pc.hardware.chips)
  • Re: Hacked or.....Would appreciate expert help
    ... I was just saying that I have spent the past two hours giving signs that I am ... online reports about being hacked. ... I spent weeks gathering evidence of hacking to send to ...
    (microsoft.public.security)
  • Re: PHP site development
    ... Having spent lots of time in the database world, I must say that I relate ... > which identifies a development environment based on the 3 tier architecture. ... > possible to build and maintain web components with much less effort. ...
    (comp.lang.php)