I have a VBA program written in Excel 97 on one machine
(machine A) with a reference pointing to ADO Ext. 2.5 for
Security and DDL. The VBA program was modified on another
machine (machine B) also running Excel 97 but with a
reference to ADO Ext. 2.6...instead.

After the modifications on machine B, the reference is no
longer ADO Ext. 2.5 and changed to pointing to ADO Ext.
2.6 now.

When re-running it on machine A, the program gave many
errors and the reference was showing "Missing ADO Ext. 2.6
for Security and DDL".

My question was how to change the settings on either of
the machines to make the program work again on machine A.
Is there anyway to downgrade to ADO Ext. 2.5 for Security
and DDL to make it run well on machine A?

Thanks a lot!