Hi all,
this might be an obvious question, but i was wondering about how to handle multi-users through using ADO.
I have my program written in tiers with the data layer accessing a Foxpro database through ODBC drivers. the resulting recordset is returned to the Business layer and the connection is closed. My question is this:

If you edit a record and make changes, is there a specific way to handle the situation where someone else has made changes to the same record? I thought about locking the record, but that wouldn't work since the connection is closed after the fetch would it (even if it did work, what about if the client side crashes)? How can i handle this? Am i doing something wrong?

thanks
Jordan