ADO: References not installed properly (?) Error 3706

[Arch Stanton]

I hate to ask such a boneheaded question, but the internet just doesn't
seem to be able to help me.

I'm running Access 2003 on MS Vista. I'm trying to write some VBA code
in a module, but I keep getting Error 3706 ("Provider cannot be found.
It may not be properly installed"). I've triple-checked my connection
string, but it's fine. I tried to install the updates I found on the
Microsoft page, but I get the message that if I'm running Vista then I
already have the most current Jet 4.0 version.

I don't think this is the problem, but for the record, here's the code
I'm using to connect to my database:

Dim objConnect As ADODB.Connection
Dim objCommand As ADODB.Command
Dim rstWaterQuality As ADODB.Recordset

Set objConnect = New ADODB.Connection

objConnect.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.00;Data
Source=W:\CurrentSWIS.mdb;"

objConnect.Open

I'm convinced that I don't have my references set up properly - either
I'm missing one or I have something that's conflicting. I have
"Microsoft Jet and Replication Objects 2.6 Library", "Microsoft Data
Access Components Installed Version", and "Microsoft ActiveX Data
Objects 2.7 Library" references installed, but I don't know what else I
need. Can someone help?

As always, thanks.

 

[Evi]

It's certainly not boneheaded.

Allen Browne has a very good section on references which may help you to
decide if yours are incorrect
http://allenbrowne.com/ser-38.html
Not only do you need the references there, but (as you probably already
know) you also need them in the correct order. I don't have 2003 so I can't
check but maybe someone out there could take a look.

I see you don't have anything with DAO but that may not be necessary for
you.


Evi

 

[daudelbert]

It's certainlynotboneheaded.

Allen Browne has a very good section on references whichmayhelpyou to
decide if yours are incorrecthttp://allenbrowne.com/ser-38.htmlNotonly do you need the references there, but (as you probably already
know) you also need them in the correct order. I don't have 2003 so I can't
check but maybe someone out there could take a look.

I see you don't have anything with DAO but thatmaynotbe necessary for
you.












- Show quoted text -

Well hello there, i also face the same problem with this kind of error
with my windows XP sp3...i spend almost 24 hours surfing and figuring
but all the solution that being offered couldn't help me. Then i try
figure it out by myself. At last i manage to find the answer to sovle
this problem. This error occurred because the registry setting is not
overwritten with the new information about the update driver version.
I have upgraded my ms access driver from jet 3.51 to 4.0 using Ms Data
Access Component 2.7. So i suggest you follow my tips :

1) Go to your windows registry and find the key [HKEY_LOCAL_MACHINE
\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0]

2) Then delete all the value names in the key for Jet 4.0

3) Reinstall/launch the file MDAC_TYPE.EXE (Ms Data Access Component )
with the latest version you've preferred.

That's all. I wish this will help you and others who faced the same
problem with this kind of error...