I have set a reference to msador15.dll and started to write a function as follows.
Dim cnn As ADODB.Connection
Set cnn = New ADOR.Connection
I then tried to compile this to check I was on the right path and I get the message "User-Defined Type not defined"
I have searched MSDN, here and some other forums but am still lost. Most examples suggest setting a reference to ADOn.n and thats what I have done.
I have tried referencing msadomd.dll and the ADO ext. 2.7 for dll and secuiity niether have helped me out.
Am I missing a simple trick or am I heading along the wrong path in the wrong woods?