How do I avoid this error message? Provider cannot be found, it may not be properly installed, when using Jet.OLEDB.3.5.1?

Posted on 2009-04-29
Last Modified: 2012-05-06
I am using VB6 with an ADO connection to open an Access 2003 database, using the code in the code box provided below, with the only difference being the following line of code..
SrcStr = "Provider=Microsoft.Jet.OLEDB.4.0;"
This works fine to open an Access 2003 Database.

However, if I use the same code but I change the Provider to Jet 3.5.1, as in the following example:
SrcStr = "Provider=Microsoft.Jet.OLEDB.3.5.1;"
to open an Access 97 database,
I get the following message:
"Provider cannot be found. It may not be properly installed".
What can I do to work out this problem?
Dim SrcStr As String

 SrcStr = "Provider=Microsoft.Jet.OLEDB.3.5.1;"

 SrcStr = SrcStr & "Password=PW;User ID=UseN;"

 SrcStr = SrcStr & "Data Source="C:\MyFile\settings.Mdb;"

 SrcStr = SrcStr & "Jet OLEDB:System database=" & App.Path & "\system.mdw"  

Dim SrcC As adodb.Connection

   Set SrcC = New adodb.Connection

   SrcC.CursorLocation = adUseClient

   SrcC.ConnectionString = SrcStr

   SrcC.Mode = adModeReadWrite


Open in new window

Question by:YomTovSuccos
    LVL 15

    Accepted Solution

    I have a couple of sujestions:

    1.) Add a reference (VB Menu -> Project -> References) to "Microsoft Active Data Objects 2.x Library

    2.) Download the latest MDAC version from microsoft.

    3.) Update your visual basic 6.0 to the latest service pack available, in which I believe is service pack 6.0.


    Author Comment

    Run-time error '3706': Provider cannot be found
    I have done all the suggestions you made and I still get the same error message. Any more ideas?
    If I use it in an Access 2003 project it's fine, and the Access 97 in the same project gives me this error message.


    Author Comment

    i treid to use  Provider=Microsoft.Jet.OLEDB.4.0 for the acces 97 database and it works fine

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now