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?