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

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

http://i70.photobucket.com/albums/i84/chrisad/OLEDB.jpg

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 :

http://i70.photobucket.com/albums/i8...ad/service.jpg

any ideas????


thanks

Chrisad

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

VB Code:

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

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

http://i70.photobucket.com/albums/i84/chrisad/DONT.jpg

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

How about the latest MDAC.Try updating to it.

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

-tg

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

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