It sounds as if you don't have a reference to the ActiveX Data Objects library (2.5, 2.6 or 2.7 depending on which one you want/need).

Vic