Results 1 to 8 of 8
  1. #1
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Database Access (VB 6)

    I'm venturing into new territory for me in that I"m trying to access an Access table from my VB program. However, after specifying the path to the Database file I get the message "Provider cannot be found." Of course, there is no clue as to what this error message means or how to get or install the "provider". Any suggestions?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Database Access (VB 6)

    Hi Chuck

    Just before we start what version of Access have you installed on your PC? VB^ only really works with 97 <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>
    Jerry

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Database Access (VB 6)

    Which data control are you using? The 'old' data control doesn't know Access 2000 or higher; the ADODC data control does.

  4. #4
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Database Access (VB 6)

    I'm using Access 2003 so that is probably the problem. However, I'm in foreign territory here with regard to what "data control" I'm using. I'm quite familiar with Access 2003, but I don't know what ADODC is or how to get/use it. I guess I need some educaton here. To access the database I simply started a new form using the "VB Data Form Wizard." However, It looks like it's more complicated than that.

    Some more information. After reading my manual a bit more it advised to start by clicking on "Add-Ins- Visual Data Manager." This results in an error message "Can't load MSJTER35".

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Database Access (VB 6)

    I don't have VB6 at the moment, so I cannot provide detailed instructions, but you should be able to add the Microsoft ADODC control to the toolbox (right-click the toolbox and select More Controls or something similar).

    You can also use ADO code to connect to an Access 2000 (or 2002/2003) database - see Visual Basic 6 ADO Tutorial.

  6. #6
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Database Access (VB 6)

    Thanks Hans. The tutorial you referenced got me far enought to read a record out of the database. I can see that I have a long way to go, however, to manage all the data that I need.

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

    Re: Database Access (VB 6)

    The ADO Data Control is probably slightly less intimidating. See Implementing An ADO Data Control With VB6.

  8. #8
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Database Access (VB 6)

    That works too. I'm learning a lot lately. Thanks.

Posting Permissions

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