Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / February 2008

Tip: Looking for answers? Try searching our database.

Missing reference library

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
wschiro - 08 Feb 2008 01:17 GMT
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 - 08 Feb 2008 15:45 GMT
Check the microsoft site for the redistributable runtime files for the same
library.

Signature

Regards,
Shyam Pillai

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

>I have written some code that populates a drop down menu from an Access
>data
[quoted text clipped - 32 lines]
>
> Code that causes error: Dim gcnAccess As New ADODB.Connection
wschiro - 23 Feb 2008 04:29 GMT
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.  

> Check the microsoft site for the redistributable runtime files for the same
> library.
[quoted text clipped - 35 lines]
> >
> > Code that causes error: Dim gcnAccess As New ADODB.Connection
wschiro - 29 Feb 2008 06:39 GMT
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/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037
-185d0506396c&displaylang=en#Overview


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

> Hi Shyam,
>
[quoted text clipped - 41 lines]
> > >
> > > Code that causes error: Dim gcnAccess As New ADODB.Connection

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.