ShowUserRosterMultipleUsers

[Carol Bell]

I have used the code located at the below site, however
when I try to run it in the Northwind database, I get the
following error.

Compile Error: User-defined type not defined

And this is where it brings be to in the code.

Sub ShowUserRosterMultipleUsers()
Dim cn As New ADODB.Connection


http://support.microsoft.com/default.aspx?scid=kb;EN-
US;285822#appliesto

 

[Tim Ferguson]

I have used the code located at the below site, however
when I try to run it in the Northwind database, I get the
following error.

Compile Error: User-defined type not defined

And this is where it brings be to in the code.

Sub ShowUserRosterMultipleUsers()
Dim cn As New ADODB.Connection

Last I knew, the Northwind demo was based on DAO. Have you looked to see if
the reference to Microsoft Activex Data Objects is checked?

Tim F

 

[Carol Bell]

-----Original Message-----


Last I knew, the Northwind demo was based on DAO. Have you looked to see if
the reference to Microsoft Activex Data Objects is checked?

Tim F

.
Thanks! That was the problem.