I don't understand your question "Would ADO be faster without object instantiation?".
I don't think that ADO would be slower.
>I just thought of automation, first.
>Would ADO be faster without object instantiation?
>The slow part has turned out to be accessing the field values.
>
>Thanks,
>Terry
>
>
>
>
>>>Can someone please tell me why the following is failing?
>>>
>>>o=createobject("DAO.DBEngine")
>>>I have tried to register w/regsvr32 dao3032.dll and get a fail, since I have Access97 installed and it probably is already registered.
>>>
>>>Using the object browser on dao2535.tlb I get dbengine is a member of DAO.
>>>
>>>Any ideas?
>>>
>>>TIA
>>
>>Why are you using DAO not ADO?
--sb--