Results 1 to 9 of 9
  1. #1
    Join Date
    Jan 2009
    Posts
    22

    Question Unanswered: I want to transfer my db to "V Basic" .....................

    Hi everyone

    I have db access and I want to convert or "transfer" fully to "V Basic"
    Is there a program or method that helps me?

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    There are third party apps that do this. They're all commercial products and cost, of course. This one has had favorable reviews, but I've never it myself:

    IrieSoftware Microsoft Access to Visual Basic 6/VB.NET Database Conversions
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jan 2009
    Posts
    22
    Thank you .....
    Is there a freeware program ?
    or
    Is it possible to import from db to Vb?

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    No freeware that I've ever seen, and not likely to be! This is a very complicated procedure and not likely to be offered for free. And no, the only other way to do this is to essentially start from scratch, using Visual Basic to create an entirely new front end (forms, queries, etc) only retaining the Access tables to be used as the backend. And if I remember correctly, reports would have to be done thru Chrystal Reports.

    The whole purpose in using Access is that you can rapidly develop a fairly sophisticated database where all aspects are included in one package.

    Why do you feel the need to convert this to Visual Basic?
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    Jan 2009
    Posts
    22
    Thank you .....
    I have a small program to convert units.
    I want to make a EXE .... because that,I want to convert this to Visual Basic.net

    Can I build again by Visual Basic.net ?

  6. #6
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    As I said, you can recreate your program in VB or VB.Net, whatever, and use Access as the back end, retaining your data. But a "small program to convert units" doesn't really sound like something that should have been done in Access to begin with. You're probably jsut as well starting from scratch in VB.

    Good luck!
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Sure, why not?! Sound simple enough.

    You can always use copy and paste between Access VBA and VB.NET code windows.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    Jan 2009
    Posts
    22
    Thank you,

    You can always use copy and paste between Access VBA and VB.NET code windows.
    But There are some errors ..For example

    For example the cod in db access

    c = a + b
    but I Vb.net
    Dim aa As Double
    Dim bb, sum1 As Double
    aa = a.Text
    bb = b.Text

    sum1 = aa + bb
    c.Text = sum1

  9. #9
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    I suspect you're going to find a lot of errors trying to use Access VBA code in a straight VB or VB.Net app. Many people make the mistake of thinking of Basic is Basic is Basic! While all three are derived from Basic (they were all written around the QuickBasic 4.5 engine) they are not the same language! Many identically named functions behave differently. Many properties behave differently. And how things are accomplished differ in many cases.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •