adodb.connection USER-defined type not defined

In the VBE select Tools -> References... From the dialog box that pops up, and find something like

Microsfot ActiveX Data Objects 2.7 Library or higher number. Select this and then compile