Have you used the COM+ deployment? Using MTS, it was generating a client setup which was registering the object to each client. This way, you can declare object in early-binding method.
>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!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com