In previous versions of Access, using ADODB required a reference to the
Microsoft ActiveX Data Object 2.x Library. I would assume it's no different
in Access 2007.
Microsoft office 12.0 access database engine objects library is the
equivalent of DAO, not ADO.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)