ADODB not defined

[Gkirkup]

I am testing a big application that I am moving from 2003 to 2010 and .accdb.
In the VBA of a form, on the line:

Dim cn as NEW ADODB.CONNECTION

I get the error, 'Compile error: User-defined type not defined'.

What do I need to do to make this work?

Robert

 

[boblarson]

Set a reference to Microsoft Active Data Objects 2.8.

 

[Gkirkup]

Bob: I am new to the 2010 menus. Where would I set a reference to Active Data Objects?

Robert

 

[boblarson]

Bob: I am new to the 2010 menus. Where would I set a reference to Active Data Objects?

Robert

The same place as in all previous versions - in the VBA Window at TOOLS > REFERENCES.