have you tried querying only for the record you want?

--
Regards,
Tom Ogilvy


"Ken Valenti" wrote:

I have a couple of applications that use ADO to update recordsets (SQL) from
an excel interface.

After opening a recordset, I set it to the beginning of the file and then do
a find.

It works, but takes several minutes to find the record.

There are only a few hundred records.
I can use the CopyFromREcordset all records appear in seconds.

I'm using the Find to select the record to edit.

Any ideas how I can speed things up?