"augustus" wrote ...

Dim objConn As ADODB.Connection
Set objConn = New ADODB.Connection

I checked the Reference, the Microsoft ActiveX Data Objects Recordset 2.7
Library has got a tick. But I get "User-defined type not defined" for the new
method, why?????????

Look at the classes in the Object Browser: you've referenced ADOR
rather than ADODB. Try checking ActiveX Data Objects 2.7 Library.

Jamie.

--