Problem with OLEDB Provider

[mahajan7]

Hello!

In my database programme, I'm using MSAccess Database. I have created connection with the database as follows:


Global cn As New ADODB.Connection

Set cn = New ADODB.Connection

With cn
.ConnectionString "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\DB.mdb"

.CursorLocation = adUseNone
.Open
End With

When the project is complete, it runs properly on WinME, WinXP, Win2000, but when I run it on Win98, I get runtime error "ADO can not find specified provider". Will you please help me in locating the problem & its solution.

I have set the project reference to
Microsoft ADO 2.0 library

Thanks in advance

[M Owen]

You have to have the proper MDAC installed ...