Moving from Access 97 to Access 2000 with VB6


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Moving from Access 97 to Access 2000 with VB6

  1. #1
    Dean Earley Guest

    Re: Moving from Access 97 to Access 2000 with VB6

    > I have many systems developed in VB6 with Access 97, using DAO to access the
    > tables (uisng OpenDatabase method) i.e.
    >
    > 'open database
    > Set db_recs = OpenDatabase(gx_path & gx_database, False, False)
    > '
    > 'open user table
    > Set tbl_user = db_recs.OpenTable("RE_USER")
    > tbl_user.Index = "primarykey"
    >
    >
    > Question:
    >
    > We are planning to move to Office 2000 (and Windows 2000) and hence Access
    > 2000. What changes (if any) are required for my applications to run with
    > Access 2000 ?


    None that I'm aware of except having to make sure you have an up to date mdac (3.6?)

    --
    Dean Earley (dean.earley@icode.co.uk)
    Assistant Developer

    iCode Systems



  2. #2
    Moben Guest

    Moving from Access 97 to Access 2000 with VB6


    I have many systems developed in VB6 with Access 97, using DAO to access the
    tables (uisng OpenDatabase method) i.e.

    'open database
    Set db_recs = OpenDatabase(gx_path & gx_database, False, False)
    '
    'open user table
    Set tbl_user = db_recs.OpenTable("RE_USER")
    tbl_user.Index = "primarykey"


    Question:

    We are planning to move to Office 2000 (and Windows 2000) and hence Access
    2000. What changes (if any) are required for my applications to run with
    Access 2000 ?

    Any ideas or further information would be greatly appreciated.

    Regards,

    MoBen.


  3. #3
    Douglas J. Steele Guest

    Re: Moving from Access 97 to Access 2000 with VB6

    "Dean Earley" <dean.earley@icode.co.uk> wrote in message
    news:3cf79a2e@10.1.10.29...
    > > I have many systems developed in VB6 with Access 97, using DAO to access

    the
    > > tables (uisng OpenDatabase method) i.e.
    > >
    > > 'open database
    > > Set db_recs = OpenDatabase(gx_path & gx_database, False, False)
    > > '
    > > 'open user table
    > > Set tbl_user = db_recs.OpenTable("RE_USER")
    > > tbl_user.Index = "primarykey"
    > >
    > >
    > > Question:
    > >
    > > We are planning to move to Office 2000 (and Windows 2000) and hence

    Access
    > > 2000. What changes (if any) are required for my applications to run with
    > > Access 2000 ?

    >
    > None that I'm aware of except having to make sure you have an up to date

    mdac (3.6?)

    Slight correction. You need to reference Microsoft DAO 3.6 Object Library.
    However, that isn't part of MDAC. Fortunately, you can download Jet 4.0 SP3
    from http://www.microsoft.com/data/download.htm#Jet4SP3info

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele





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