Re: active data objects library 2.7's use with Windows 2000 sp3

From: Val Mazur (group51a_at_hotmail.com)
Date: 06/24/04 

Date: Wed, 23 Jun 2004 22:01:30 -0400

Hi Gordon,

You might have two situations:
- MDAC 2.7 is not installed on your PC. Windows 2000 comes with MDAC 2.6 and
if you did not install MDAC 2.7 separately, then your application will miss
the reference.
- If this is not the case then try to run Component Checker utility, which
ships with MDAC to see if MDAC installation is not corrupted. Otherwise you
should see reference 

-- 
Val Mazur
Microsoft MVP
"Gordon" <Gordon@discussions.microsoft.com> wrote in message 
news:47E84080-A732-430C-B8B5-5D8EBD1610DE@microsoft.com...
>I have a spread*** that was created in Office 2003
>
> I am using the ado library 2.7 reference in the VB code
>
> On Windows 2000 machines with SP3, I get errors that say it cannot connect 
> to the database.  when I look at the references of the project, it says 
> the active x data object 2.7 is missing.
>
> Is this a problem with windows 2000?  If not, how do I load this library 
> and all compatible libraries that need to go with it.  Is this a VBA 
> runtime installation issue?
>
> thanks for any help you can give......