Jerry,

It sounds like you don't have the Microsoft ActiveX reference set. Within the VBA Editor go to TOOLS REFERENCES and check the box next to "Microsoft ActiveX Data Objects 6.0 Library" (or the highest version number you have, if there is no 6.0 option).

Once the reference has been set, you can click Debug Compile VBAProject to see if it still gives you an error.

Ben