Access 97=>VB6


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Access 97=>VB6

  1. #1
    Douglas Guest

    Access 97=>VB6

    Hi all,

    I have a database, made in Access 97, and I want to convert it to a VB 6
    application.

    Is this possible/easy?

    How? Could some one point me in the direction of an example on the net?

    Thanks,
    Doug



  2. #2
    Arthur Wood Guest

    Re: Access 97=>VB6


    Unfortunately there is no easy way to do this. The biggest problem is that
    many of the controls in Access ARE NOT the same control (though the look
    the same) as found in VB 6. For instance the Combo Box control in Access
    supports such Events as NotInList and properties such as LimitToList, which
    are not found in the VB6 CmboBox control. Also, with the Access Combo Box,
    as you enter charaters for the list, the list automatically scrolls to locate
    the first entry with those characters. Again a feature not found in the VB
    6 control. This is a very short list of specific differences for a specific
    control. There are lots of other examples.

    There is also no method for exporting an Access form, as a file, outsidfe
    of the Access environment.

    On the other side of the coin, there are lots of capabilities in VB 6 for
    which there is no corresponding capability in Access 97. In VB 6 your objects
    can raise events, while Access 97 does not support the WithEvents keyword,
    or the RaiseEvent procedure call.

    With all of this, it is fairly clear that you will need to write the VB 6
    version of the App essentially from scratch. Yes, you can cut and pate event
    handler code from the Access code modules, to the corresponding VB code modules,
    but you will probably find that this is a good time to completely re-think
    the architecture of the application, given the Object-Oriented capabilities
    that you will have in VB 6.

    Just my humble opinion, and I am sure that others will jump in to this discussion
    with their two cents worth.

    Enjoy the ride. :-)

    Arthur Wood
    "Douglas" <hot_n_cold_2000@hotmail.com> wrote:
    >Hi all,
    >
    >I have a database, made in Access 97, and I want to convert it to a VB 6
    >application.
    >
    >Is this possible/easy?
    >
    >How? Could some one point me in the direction of an example on the net?
    >
    >Thanks,
    >Doug
    >
    >



  3. #3
    challis Guest

    Re: Access 97=>VB6


    You can use withevents, but you cannot raise an event.

    The question here I think most appropriate: Why would you want to convert
    the Access app to vb6. You can get the developers edition of access and ship
    the required run time files royalty free. Ie compile your access app and
    ship it almost as if it were a VB execuatable

    challis



    "Arthur Wood" <wooda@saic-trsc.com> wrote:
    >
    >Unfortunately there is no easy way to do this. The biggest problem is that
    >many of the controls in Access ARE NOT the same control (though the look
    >the same) as found in VB 6. For instance the Combo Box control in Access
    >supports such Events as NotInList and properties such as LimitToList, which
    >are not found in the VB6 CmboBox control. Also, with the Access Combo Box,
    >as you enter charaters for the list, the list automatically scrolls to locate
    >the first entry with those characters. Again a feature not found in the

    VB
    >6 control. This is a very short list of specific differences for a specific
    >control. There are lots of other examples.
    >
    >There is also no method for exporting an Access form, as a file, outsidfe
    >of the Access environment.
    >
    >On the other side of the coin, there are lots of capabilities in VB 6 for
    >which there is no corresponding capability in Access 97. In VB 6 your objects
    >can raise events, while Access 97 does not support the WithEvents keyword,
    >or the RaiseEvent procedure call.
    >
    >With all of this, it is fairly clear that you will need to write the VB

    6
    >version of the App essentially from scratch. Yes, you can cut and pate

    event
    >handler code from the Access code modules, to the corresponding VB code

    modules,
    >but you will probably find that this is a good time to completely re-think
    >the architecture of the application, given the Object-Oriented capabilities
    >that you will have in VB 6.
    >
    >Just my humble opinion, and I am sure that others will jump in to this discussion
    >with their two cents worth.
    >
    >Enjoy the ride. :-)
    >
    >Arthur Wood
    >"Douglas" <hot_n_cold_2000@hotmail.com> wrote:
    >>Hi all,
    >>
    >>I have a database, made in Access 97, and I want to convert it to a VB

    6
    >>application.
    >>
    >>Is this possible/easy?
    >>
    >>How? Could some one point me in the direction of an example on the net?
    >>
    >>Thanks,
    >>Doug
    >>
    >>

    >



  4. #4
    Douglas Guest

    Re: Access 97=>VB6

    But do I have the Dev version...nooo.....

    Thanks anyway,
    Doug

    "challis" <bmlx@yahoo.com> wrote in message news:39fedce6$1@news.devx.com...
    >
    > You can use withevents, but you cannot raise an event.
    >
    > The question here I think most appropriate: Why would you want to convert
    > the Access app to vb6. You can get the developers edition of access and

    ship
    > the required run time files royalty free. Ie compile your access app and
    > ship it almost as if it were a VB execuatable
    >
    > challis
    >
    >
    >
    > "Arthur Wood" <wooda@saic-trsc.com> wrote:
    > >
    > >Unfortunately there is no easy way to do this. The biggest problem is

    that
    > >many of the controls in Access ARE NOT the same control (though the look
    > >the same) as found in VB 6. For instance the Combo Box control in Access
    > >supports such Events as NotInList and properties such as LimitToList,

    which
    > >are not found in the VB6 CmboBox control. Also, with the Access Combo

    Box,
    > >as you enter charaters for the list, the list automatically scrolls to

    locate
    > >the first entry with those characters. Again a feature not found in the

    > VB
    > >6 control. This is a very short list of specific differences for a

    specific
    > >control. There are lots of other examples.
    > >
    > >There is also no method for exporting an Access form, as a file, outsidfe
    > >of the Access environment.
    > >
    > >On the other side of the coin, there are lots of capabilities in VB 6 for
    > >which there is no corresponding capability in Access 97. In VB 6 your

    objects
    > >can raise events, while Access 97 does not support the WithEvents

    keyword,
    > >or the RaiseEvent procedure call.
    > >
    > >With all of this, it is fairly clear that you will need to write the VB

    > 6
    > >version of the App essentially from scratch. Yes, you can cut and pate

    > event
    > >handler code from the Access code modules, to the corresponding VB code

    > modules,
    > >but you will probably find that this is a good time to completely

    re-think
    > >the architecture of the application, given the Object-Oriented

    capabilities
    > >that you will have in VB 6.
    > >
    > >Just my humble opinion, and I am sure that others will jump in to this

    discussion
    > >with their two cents worth.
    > >
    > >Enjoy the ride. :-)
    > >
    > >Arthur Wood
    > >"Douglas" <hot_n_cold_2000@hotmail.com> wrote:
    > >>Hi all,
    > >>
    > >>I have a database, made in Access 97, and I want to convert it to a VB

    > 6
    > >>application.
    > >>
    > >>Is this possible/easy?
    > >>
    > >>How? Could some one point me in the direction of an example on the net?
    > >>
    > >>Thanks,
    > >>Doug
    > >>
    > >>

    > >

    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center