Your choice of tools are good ( SQL Server,VB and ADO). You will want to avoid keeping recordsets open for a long time. In other words 1)Get the record(s) 2)modify locally and 3) send update back to server. Your update procedure should make sure that no one else has changed the record in the meantime (use timestamps).