Missing ADO error message.....

[doran_doran]

Hello,

I have a database and about 50 people are using the same database. But some people (so far 3 people) were getting compiling error. So, I went to their computer and went to module and went to References. And it show missing for Microsoft ActiveX Data Objects 2.7 Library (location c:\program files\common files\system\ado-2\msado15.dll.

OK, here comes the funny part. I did not refence to ado-2 subdirectory. As a matter of fact, all the working machine points to ado folder and vb or vba code works fine. Except those three machine were saying the refence is missing. Of course, becasue there are not ado-2 folder.

What is going on? Those three people did have ado subfolder and all msado15.dll file. For interim, I did create ado-2 subfolder and copy all the dll and other stuff from ado to newly created ado-2 subfolder.

Any idea why this is happening.

Thanks
Dianna

 

[Shadez]

Not a problem what you are missing is the latest copy of mdac (microsoft data access components) 2.7?, avalicable free from microsoft.

download and install on the problem machines and all will be sorted

 

[fuzzygeek]

MDAC

It is important to insure that each user is running the same version of the MDAC in order to keep compatibility. The site to get to the MDAC versions is :

http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp

 

[doran_doran]

thanks guyzzzz.

Thank you all for pitch. in.

It helps to think clearly when another angle is shown.

thanks again.

Dianna
Dianna@webcultivator.com