ADODB type missing?

[Mike P]

I have been working in 2007 the entire time, just had the db set to 2003
capability mode. Now I updated my Access 2003 db to Access 2007 using Import
External Data as I split the FrontEnd (program) from the BackEnd (data).
Some of my modules are getting a User Defined Type undefined, which is the
ADODB. The line that is failing in the 2007 version is
Dim cn As ADODB.Connection

Help ! ! Any ideas here?

 

[Mike P]

Got it! It was a references problem.

1. From any code module, select References from the Tools menu.
2. You may see an item marked ***MISSING*** - untick it.
3. Find Microsoft ActiveX Data Objects Library, and tick it.
4. Click OK.