I am working on a vb6 application and access as database
In that i am making the application multiuser.
In that i am updating , inserting , deleting records using sql statments.
now I want that whenever I do updating the record then at that time , I want to apply some kind of lock so that other user can not do anything on that particular record till the user finishes his work.
so Is there is any way to lock a record in access using vb6 (Remember i am sql statments)