Use a different cursor type. The default cursor is read-only.

Or show some code...

Tim


"Ken Valenti" wrote in message
...
I am using ADO to edit data in a SQL database.

My problem is how to select a record.

Using "Find" on the recordset works, but takes several minutes.

Using "Excecute" on the connection to run a SQL query only takes seconds
(thanks Tom!), but then the recordset is not editable.