Microsoft.jet.oledb.4.0 it make me crazy!

[Chrisad]

hello to all,

I m using WinXP pro SP2 and VB6 SP6

i try to use Microsoft.jet.oledb.4.0 on my prog but i cant find it

my provider list does not include Microsoft.jet.oledb.4.0



i search my system for Msjet40.dll and i find it :

in C:\WINDOWS\system32
and

in C:\WINDOWS\ServicePackFiles\i386

i register both dlls with

regsvr32 C:\WINDOWS\system32\msjet40.dll command

but i steel cant use it on my prog....

finaly i try to install latest service pack Jet 4.0 Service Pack 8

and i take this message :



any ideas????


thanks

Chrisad

[lintz]

This is how I connect to my databases (if it helps)

Dim cn As New ADODB.Connection
 
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                 "Data Source=" & App.Path & "\DataBaseName.mdb"

[Chrisad]

the same error and with this way.....

[Chrisad]

anybody?? ....... help!~

[litlewiki]

How about the latest MDAC.Try updating to it.

[techgnome]

Don't grab the latest.... it doesn' have the jet drivers....That maybe the problem. get MDAC2.6....

-tg

[brucevde]

msjetoledb40.dll is the Jet 4.0 OLEDB provider (msjet40.dll is the Jet Database Engine). Try registering msjetoledb40.dll.

[Chrisad]

i try MDAC 2.6.... but nothing ***/?!!