thank you for your replies, most kind

i still am kinda lost
first time i written a standalone app is used by few pcs at the same time to access the same db

basically what am trying to do is avoid bad data in the database, and the crashing of the database

so if one user is editing a record,
i dont want another user to access that record at all
until the first user is done what he is doing

i just like to know if there is a article, tutorial somewhere in can read on this..

thankyou