缺少“Microsoft ActiveX数据对象2.8库”参考 [英] Missing "Microsoft ActiveX Data Objects 2.8 Library" Reference
问题描述
I have written some VBA code in PwerPoint 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 SP2
Missing reference Library: Microsoft ActiveX Data Objects 2.8 Library
Missing file: msado.15dll
Directory: C:\Program Files\Common Files\System\ado\ (when looking in the directory the file is there [msado.15dll] but, going to tools>reference the pop-up box shows that it is missing.
Code line that causes error: Dim gcnAccess As New ADODB.Connection
推荐答案
我找到了解决问题的简单方法。 不检查我的PowerPoint中的Microsoft ActiveX Data Objects 2.8参考库文件（工具>参考）并让用户安装它你没有运行任何问题将是msao15.dll文件的不同版本。 实际上有一个用户有Microsoft ActiveX数据对象2.5，这很好。
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.
当然这种方法对每个人都不适用。 您可能不希望用户有权访问您的VBA代码。 因为这只会在我的组中使用，所以我可以很容易地让一个同事添加远程计算机上的参考库。
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.
在Microsoft知识库中，您可以下载程序进行检查哪个版本安装在系统上的Microsoft数据访问组件（MDAC）的版本。
http://support.microsoft.com/kb/301202
我下载文件，发现那里有不同版本的maso15.dll文件。 我认为这一定是为什么它表明参考库丢失了，但是当我走到那里的路径时，假设文件就在那里。 我正在寻找MDAC 2.8版本的可再发行安装程序将在我们所有的计算机上运行它15-20。 我在MS知识库中阅读了一些在测试环境中执行此操作的地方，因为它可能会导致一些问题。 我决定不去这条路线，除非我不得不这样做，因为我已经通过将我的maso15.dll文件复制到他们的机器上来杀死一台机器上的Office应用程序。 一点知识可能很危险。
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.
< font face ="Times New Roman"size = 3>
MDAC 2.8可再发行安装程序
我希望这可以帮助其他可能出现同样问题的人。
这篇关于缺少“Microsoft ActiveX数据对象2.8库”参考的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
