Missing reference library

[wschiro]

I have written some code that populates a drop down menu from an Access data
base. The code works fine on my machine. On another machine I am missing
the reference library to Microsoft ActiveX Data Objects 2.8 Library. I found
this file on my machine and then copied in into the other machine and all
worked well afterwards.

On two remote machines the same problem arises. They are missing the
Microsoft ActiveX Data Objects 2.8 Library but, when checking the directory
the file is there. I had my co-worker replace the file that’s on my machine
with the one in the remote machine and no luck. I even tried rebooting and
still no luck.

Any suggestion?

More Details:

All machines are HP/Compaq laptops 6200s

OS: 2000 Professional

Office app: PowerPoint 2003. I am not sure of the service pack on the other
machines.

Missing reference Library: Microsoft ActiveX Data Objects 2.8 Library

Missing file: msado.15dll

Directory: C:\Program Files\Common Files\System\ado\

Code that causes error: Dim gcnAccess As New ADODB.Connection

 

[Shyam Pillai]

Check the microsoft site for the redistributable runtime files for the same
library.


--
Regards,
Shyam Pillai

Animation Carbon: Copy/Paste/Share animation libraries.
www.animationcarbon.com

 

[wschiro]

Hi Shyam,

Thanks for your response. I am looking into what files I need and will post
the solution once I get it working. You where helpful in pointing me in the
right direction.

 

[wschiro]

I found a simple solution to my problem. By not checking the reference
library to Microsoft ActiveX Data Objects 2.8 in my PowerPoint file
(Tools>Reference) and letting the user install it you did not run in to any
problems will different version of the msao15.dll file. In fact one user had
Microsoft ActiveX Data Objects 2.5 and this worked fine.

Of course this method will not work for everyone. You might not want the
user to have access to your VBA code. Since this will only be used in my
group I can easily have one co-worker add the reference library on the remote
computers.

In the Microsoft knowledge base you can download a program to check which
version of Microsoft Data Access Components (MDAC) that is installed on a
system.

http://support.microsoft.com/kb/301202

I download the file and discovered that there where different version of the
maso15.dll file. I figured this must be why it showed that the reference
library was missing but when I went to the path of where it was suppose to be
the file was there. I was looking in to the redistributable installer for
the MDAC 2.8 release and was going to run it on all our computers 15-20. I
read some where in the MS knowledge base to do this in a test environment
because it may cause some problems. I decide not to go this route unless I
had to because I already kill the Office applications on one machine by
copying my maso15.dll file to their machine. A little knowledge can be
dangerous.

MDAC 2.8 redistributable installer

http://www.microsoft.com/downloads/...b7d-b037-185d0506396c&displaylang=en#Overview

I hope this helps anyone else that might have this same issue arise with them.