Yes the component is a COM+ component on a remote server. I switched my code to use CreateObject but I can't:
Dim robjUserData As UserData
I have to use:
Dim robjUserData As Object
Otherwise, I get "Error loading DLL".
>In your original question, you were talking about COM+. Is your component sited in COM+ on a server? In this case, you need to use CreateObject but you should be able to declare your object variable this way:
>
>Dim robjUserData As UserData
>
>
>
>>Obviously a typo. For early-binding it should be:
>>
>>Dim U as New clsUser
>>Dim RS As Recordset
>>Dim robjUserData As UserData
>>
>>Set robjUserData = New UserData
>>...
>>
>>Back to the original question, any thoughs on what's going on???
>>
>>>>
>>>>Early-binding with "References" set:
>>>>
>>>> Dim U As New clsUser
>>>> Dim RS As Recordset
>>>> Dim robjUserData As UserData
>>>> Dim robjUserData As Object
>>>
>>>You have declared the same object twice!
It's "my" world. You're just living in it.