As is often the case there are several ways to Skin a cat in programming - what I would like to know is what is the best/preferred way of providing Multi-user VB prog with Access97 using ADO (because want to easily upgrade to SQL server if need to). I.e. if user edits record which another edited between them viewing and editing then handle it by asking which update to use ( "Original field value=200, other user set it to 230, you set it to 250 - which do you want?"). I think optimistic locking would be best.
Thanks in advance.
Regards,
John.