>Do you keep the recordset active to prevent other people to use it or you close the recordset after the select?
>
>If you close the recordset how do you check if the data was not changed by someone else?
I always use a SQL UPDATE query. If record was changed, an error is raised.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com