ADO on Win2000 problem

[sisan]

I use ADO to access my Access 2000 database. But in Win2000, when run the line :

Set myConn = New Connection

an error appear with the message:
Automation Error
The specified module could not be found.

When I run the code in Win XP or Win 98, there is no problem with it.

The other strange thing when I use the AdoDC component, If I click on [Build] to browse the Connectionstring, there is nothing shown, unlike if I use Win XP or Win 98.

Any suggestion?

 

[Inwoner]

It might be that you do not have the ADO (or the correct version) of ADO installed.

Go to project \ references and see what version of ADO are you project referencing. Try changing to a different version of ADO (I had problems with ADO 2.7, when I have changed back to 2.6, my problems disappeared)