Hi Lotte

Since you are attempting to use ADO and not DAO (be sure you are actually trying to use ADO to make the connection) then you need to reference the Microsoft ActiveX Data Objects 2.X library via Tools>References rather than a DAO library.

Richard