Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing a Project (VB 6/Net)

    I have a project I made in Access that I use for one week out of the year. For next year, I would like create the project in VB and just use Access as a backend database. Much of the new version I am planning on creating will have the same form structure so I was wondering if there was a way to import an Access application into a VB project. I have VB 6 and Net, although I am a little more familiar with 6 so I would like to do it with 6. I will convert to Net if it will help.

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Importing a Project (VB 6/Net)

    The simple answer is No. Access uses an entirely different kind of forms and reports than VB uses. There is an application called AccessToVB, from Greenwich Financial Modeling that sort of converts them to equivalent VB objects, but it's far from perfect and you have to do a lot of cleanup after it. It is also on the pricey side for a one-time use.
    Charlotte

  4. #3
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing a Project (VB 6/Net)

    Thanks, I'll go ahead a redesign them. I just thought I would ask before I took the time.

  5. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,482
    Thanks
    3
    Thanked 41 Times in 41 Posts

    Re: Importing a Project (VB 6/Net)

    You are likely aware that building forms in VB is a good deal more timeconsuming than it is in Access - if you have a working Access system why change to VB?
    Wendell

  6. #5
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing a Project (VB 6/Net)

    Well this last year I had a problem obtaining Access licenses for all the computers (13) that were used as the front end of the database. I thought I would only need a license for the one Access used as the backend and then just install the VB program on the workstations.

  7. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 15 Times in 15 Posts

    Re: Importing a Project (VB 6/Net)

    Depending on the complexity of the front end, completely redeveloping it in VB6 might well be more expensive than licenses for Access for all PC's <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

    An alternative would be to obtain one license for the Office Developer Edition (ODE); you can then install copies of Access Runtime on the other PC's, and still use the Access front end. ODE allows unlimited distribution of Access Runtime, and the users wouldn't need to have the full version of Access on their PC's. The front end database will probably need some tweaking to get it to work in the Access Runtime environment, but that's likely to be much less work than starting from scratch in VB6!

Posting Permissions

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