ADO Connection

[Maritza]

I'm currently working with Access 97 on a Windows NT enviroment on a LAN. I'm establishing a connection using the following code;

dim cnx1 as ADODB.connection
dim strDBName as string
dim strConStr as string

strDBName = CurrentDB.Name
strConStr = "Provider = Microsoft.Jet.OLEDB.3.51;Data Source="
Set cnx1 = New ADODB.connection
cnx1 = strConStr & strDBName & ";"
cnx1.open

This code works when I run the application from my computer, but when I tried to run it from another computer I get the error message "Run-time error '3706' ADO could not find the specified provider

What is exactly causing this problem? Does anyone knows a fix for it?

Thanks,
Maritza

 

[Tim K.]

It has to do with Microsoft Data Access Components (MDAC). Make sure that you have the same version installed. Or check the latest version available at Microsoft Site