compile error... ADODB connection

Hello all,

I have a problem with the ADODB connection... and I do not understand
because yesteday worked fine and today not.

I have this mistake ...

compile error, User-defined type not defined

This is my code

Sub test()

'---------------------------------------
'Connection to sql server
'---------------------------------------
'Set up a connection
Set Cnx = New ADODB.Connection

Dim cmd As ADODB.Command ...

Thanks,

ina

As a guess you have not got a reference to the ADODB library. Look in Tools
-> References for an item marked as missing "Missing: Microsoft ActiveX Data
Objects..." Uncheck this item and find a version of that library that you do
have.

As an aside, you should declare your connection object with a dim statement
something like this...

Sub test()
Dim Cnx as ADODB.Connection
'---------------------------------------
'Connection to sql server
'---------------------------------------
'Set up a connection
Set Cnx = New ADODB.Connection

Dim cmd As ADODB.Command ...

--
HTH...

Jim Thomlinson


"ina" wrote:

> Hello all,
>
> I have a problem with the ADODB connection... and I do not understand
> because yesteday worked fine and today not.
>
> I have this mistake ...
>
> compile error, User-defined type not defined
>
> This is my code
>
> Sub test()
>
> '---------------------------------------
> 'Connection to sql server
> '---------------------------------------
> 'Set up a connection
> Set Cnx = New ADODB.Connection
>
> Dim cmd As ADODB.Command ...
>
> Thanks,
>
> ina
>
>

Thanks I did it and it works
Ina