reference to MS ActiveX Data Objects 2.8 Lib

I've written some code that requires the MS ActiveX Data Objects 2.8 Library. I've exported the book as an excel addin (.xla) and installed it on another computer. Apparently, that computer doesn't have this library and the code won't run. It gets hung up on:

Please Login or Register  to view this content.

Both computers have Microsoft DAO 3.6 Object Library. I don't know if its even the same thing. But when I un-reference the 2.8 and reference the 3.6, the code still won't work. It gets hung up on the same spot. Is there a way I can encapsule the 2.8 library with my xla so it works on any computer? or is there a way I can re-write my code to work with 3.6? Or are these 2 libraries not even related to each other? Also, I'm using Office 2007 on both computers if that matters, but I'd like my code to work with old versions also.

Below is my entire code. It just queries a SQL server.

Thx

Please Login or Register  to view this content.

DAO and ADO are different beasts... you need to reference the Active X Data Object library ... are there any listed ? (2.5 etc.. 2007/Vista I think uses 6.0). If none listed you will need to install MDAC Components to the client in question.