Access 2000 automation from VB6


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Access 2000 automation from VB6

  1. #1
    Mak Foka Guest

    Access 2000 automation from VB6


    Can an Access 2000 database be opened from VB6?

    I have a code that uses Access 97 databases. When I upgrade to
    Access 2000 the code stops working for any database converted to Access 2000
    format- Error "Unrecognized data format". Even newly created Access 2000
    databases can not be opened from VB6.
    The weird thing is that I can still open any Access 97 database form VB6
    after the installation of Access 2000. The SR-1 office patch doesn't help.

    Is there any known compatibility issue between VB6 and Access 2000?

    Mak
    Share on Google+

  2. #2
    Deborah Kurata Guest

    Re: Access 2000 automation from VB6

    How are you opening the database?

    Mak Foka wrote in message <38fcaa9e$1@news.devx.com>...
    >
    >Can an Access 2000 database be opened from VB6?
    >
    >I have a code that uses Access 97 databases. When I upgrade to
    >Access 2000 the code stops working for any database converted to Access

    2000
    >format- Error "Unrecognized data format". Even newly created Access 2000
    >databases can not be opened from VB6.
    >The weird thing is that I can still open any Access 97 database form VB6
    >after the installation of Access 2000. The SR-1 office patch doesn't help.
    >
    >Is there any known compatibility issue between VB6 and Access 2000?
    >
    >Mak



    Share on Google+

  3. #3
    Peter McKown Guest

    Re: Access 2000 automation from VB6


    I think Ms. Kurata hints at the most possible cause: how are you opening
    the file? I noticed that when using ADO I had to reference the provider
    as "Microsoft.Jet.OLEDB.4.0" rather than "Microsoft.Jet.OLEDB.3.51"

    Good luck!


    "Mak Foka" <mfoka@bispoint.com> wrote:
    >
    >Can an Access 2000 database be opened from VB6?
    >
    >I have a code that uses Access 97 databases. When I upgrade to
    >Access 2000 the code stops working for any database converted to Access

    2000
    >format- Error "Unrecognized data format". Even newly created Access 2000
    >databases can not be opened from VB6.
    >The weird thing is that I can still open any Access 97 database form VB6
    >after the installation of Access 2000. The SR-1 office patch doesn't help.
    >
    >Is there any known compatibility issue between VB6 and Access 2000?
    >
    >Mak


    Share on Google+

  4. #4
    Mak Foka Guest

    Re: Access 2000 automation from VB6


    Thanks Peter,
    Your hint was very helpfull. I Checked the Office2000 web site
    and realized that DAO3.6 was used in Access2000 and my application was still
    referencing the DAO 3.51 library.
    Mak

    "Peter McKown" <mckown@ohio.edu> wrote:
    >
    >I think Ms. Kurata hints at the most possible cause: how are you opening
    >the file? I noticed that when using ADO I had to reference the provider
    >as "Microsoft.Jet.OLEDB.4.0" rather than "Microsoft.Jet.OLEDB.3.51"
    >
    >Good luck!
    >
    >
    >"Mak Foka" <mfoka@bispoint.com> wrote:
    >>
    >>Can an Access 2000 database be opened from VB6?
    >>
    >>I have a code that uses Access 97 databases. When I upgrade to
    >>Access 2000 the code stops working for any database converted to Access

    >2000
    >>format- Error "Unrecognized data format". Even newly created Access 2000
    >>databases can not be opened from VB6.
    >>The weird thing is that I can still open any Access 97 database form VB6
    >>after the installation of Access 2000. The SR-1 office patch doesn't help.
    >>
    >>Is there any known compatibility issue between VB6 and Access 2000?
    >>
    >>Mak

    >


    Share on Google+

Similar Threads

  1. Moving from Access 97 to Access 2000 with VB6
    By Dean Earley in forum VB Classic
    Replies: 2
    Last Post: 05-31-2002, 08:39 PM
  2. Access 2000, VB6, ADO2.5 - Multiuser Environment
    By Santosh in forum VB Classic
    Replies: 3
    Last Post: 05-08-2001, 12:15 PM
  3. Access 2000 DB via DSN-Less ASP Connection...
    By JimmyD in forum VB Classic
    Replies: 1
    Last Post: 01-24-2001, 07:13 PM
  4. Access 2000 automation from VB6
    By Mak Foka in forum authorevents.kurata
    Replies: 0
    Last Post: 04-18-2000, 04:44 PM
  5. Will Access 97 databases work in Access 2000?
    By FloridaSteve in forum VB Classic
    Replies: 2
    Last Post: 03-23-2000, 10:45 AM

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