?
Solved

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
3
Medium Priority
?
467 Views
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
   SrcC.Open

Open in new window

0
Comment
Question by:YomTovSuccos
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
JackOfPH earned 2000 total points
ID: 24266841
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.

0
 

Author Comment

by:YomTovSuccos
ID: 24271581
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.

0
 

Author Comment

by:YomTovSuccos
ID: 24271981
i treid to use  Provider=Microsoft.Jet.OLEDB.4.0 for the acces 97 database and it works fine
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

839 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