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
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