You need to keep a server-sided cursor with a Pessimistic locking. Finally, you must update the recordset object directly (instead of using SQL queries).
Don't forget that a complete page (8K of data if you use SQL Server) is locked when you do this!
>Using ADO, anyone know how I can determine of a record
>is in use by another?
>
>I'd like to determine this before I allow the user to
>edit the record.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com