DAO has a lot of instantiation of objects involved and getting the field values has proven to be very slow if looped over all fields for many records. I was wondering if you had experience with the speed difference.
Thanks for your input.

>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?