Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Newbie to programming

Discussion in 'Information Technology' started by Bryan, Nov 17, 2005.

  1. Bryan

    Bryan
    Expand Collapse
    Guest

    Ok, so why can't VB 6.0 access data from an Access 2003 database? I should be
    using Jet 4.0, right? (The form worked when I used Access 2000)
     
  2. Loading...

    Similar Threads Forum Date
    Newbie here, just wanted to introduce myself Interfaith Dialogues Jan 18, 2005

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    "Bryan" <twinparadox8@msn.com> wrote in message
    news:0CF2D476-254E-4F2D-9F4E-7DD8B9D73178@microsoft.com...
    > Ok, so why can't VB 6.0 access data from an Access 2003 database? I should

    be
    > using Jet 4.0, right? (The form worked when I used Access 2000)


    The structure of Jet files (MDBs) changed from Access 2000 to 2002. 2002 and
    2003 are the same. All of those versions will read files stored in the
    Access 2000 version.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access
     
  4. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    Access 2003 and Access 2000 defaults to the same JET 4.

    In addition, if you use VB, you are not using Access 2003 or Access 2000
    file-format at all. You are using only the JET component of the database
    file which is the same.

    --
    HTH
    Van T. Dinh
    MVP (Access)



    "Bryan" <twinparadox8@msn.com> wrote in message
    news:0CF2D476-254E-4F2D-9F4E-7DD8B9D73178@microsoft.com...
    > Ok, so why can't VB 6.0 access data from an Access 2003 database? I should
    > be
    > using Jet 4.0, right? (The form worked when I used Access 2000)
     
  5. Bryan

    Bryan
    Expand Collapse
    Guest

    So you're saying I shouldn't be having this problem?

    "Arvin Meyer [MVP]" wrote:

    > "Bryan" <twinparadox8@msn.com> wrote in message
    > news:0CF2D476-254E-4F2D-9F4E-7DD8B9D73178@microsoft.com...
    > > Ok, so why can't VB 6.0 access data from an Access 2003 database? I should

    > be
    > > using Jet 4.0, right? (The form worked when I used Access 2000)

    >
    > The structure of Jet files (MDBs) changed from Access 2000 to 2002. 2002 and
    > 2003 are the same. All of those versions will read files stored in the
    > Access 2000 version.
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    >
    >
     
  6. G. Vaught

    G. Vaught
    Expand Collapse
    Guest

    You may need to install a different MDAC version such as 2.1 to 2.8 for VB 6
    to 'talk' to Access 2003. Also remember you should use ADO and not DAO.

    "Bryan" <twinparadox8@msn.com> wrote in message
    news:0CF2D476-254E-4F2D-9F4E-7DD8B9D73178@microsoft.com...
    > Ok, so why can't VB 6.0 access data from an Access 2003 database? I should
    > be
    > using Jet 4.0, right? (The form worked when I used Access 2000)
     
  7. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    If the file structure is in Access 2000, you shouldn't be having the
    problem. Obviously, VB6 won't be able to read file structures that were
    developed after its release.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Bryan" <twinparadox8@msn.com> wrote in message
    news:201903CB-93E8-4384-A6A6-C2F2093F353F@microsoft.com...
    > So you're saying I shouldn't be having this problem?
    >
    > "Arvin Meyer [MVP]" wrote:
    >
    > > "Bryan" <twinparadox8@msn.com> wrote in message
    > > news:0CF2D476-254E-4F2D-9F4E-7DD8B9D73178@microsoft.com...
    > > > Ok, so why can't VB 6.0 access data from an Access 2003 database? I

    should
    > > be
    > > > using Jet 4.0, right? (The form worked when I used Access 2000)

    > >
    > > The structure of Jet files (MDBs) changed from Access 2000 to 2002. 2002

    and
    > > 2003 are the same. All of those versions will read files stored in the
    > > Access 2000 version.
    > > --
    > > Arvin Meyer, MCP, MVP
    > > Microsoft Access
    > > Free Access downloads
    > > http://www.datastrat.com
    > > http://www.mvps.org/access
    > >
    > >
    > >
     
  8. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    "Bryan" <twinparadox8@msn.com> wrote in message
    news:201903CB-93E8-4384-A6A6-C2F2093F353F@microsoft.com...
    > So you're saying I shouldn't be having this problem?


    Also, if you are using ADO you may be able to use your forms in Access 2003
    if you upgrade to MDAC 2.8.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access
     
  9. Bryan

    Bryan
    Expand Collapse
    Guest

    Thank you. I'll try that.

    "G. Vaught" wrote:

    > You may need to install a different MDAC version such as 2.1 to 2.8 for VB 6
    > to 'talk' to Access 2003. Also remember you should use ADO and not DAO.
    >
    > "Bryan" <twinparadox8@msn.com> wrote in message
    > news:0CF2D476-254E-4F2D-9F4E-7DD8B9D73178@microsoft.com...
    > > Ok, so why can't VB 6.0 access data from an Access 2003 database? I should
    > > be
    > > using Jet 4.0, right? (The form worked when I used Access 2000)

    >
    >
    >
     
  10. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "Arvin Meyer [MVP]" <a@m.com> wrote

    > If the file structure is in Access 2000, you shouldn't be having the
    > problem. Obviously, VB6 won't be able to read file structures that were
    > developed after its release.


    Access 2002 and Access 2003 both use Jet 4.0, just like Access 2000. The
    _Access_ part of later MDBs has some changes, but the tables and data ought
    to be OK. If you link the proper DAO or ADO library, I'd think it could
    work.

    Larry
     

Share This Page