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

From: Gordon (Gordon_at_discussions.microsoft.com)
Date: 06/23/04


Date: Wed, 23 Jun 2004 08:21:03 -0700

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......