Opening Access problem

[DF]

I am receiving the following error when trying to open a connection to an Access data base. "Run Time Error 3706 Provider Can't be found. It may not be properly installed.

SC = "Provider=microsoft.jet.oledb.4.0; Data source = mydb.mdb;persist security info=false"

Dim Cn as ADODB.Connection
Set CN = New ADODB.Connection
Cn.connectionstring = SC
Cn.Open

I can open the data base using Access on the desktop and the following code works on 6 other stations. I'm just having problems on this one machine. I re-installed the app, but the same error appears. Any help would be appreciated

DF

 

[CasperTFG]

Thsi was answered here. thread792-99494 so rather than re-invent the wheel, click the link and go to town. Craig, mailto:sander@cogeco.ca

Remember not to name the Lambs...
It only makes the chops harder to swallow