I am creating a local network-based project in vb6 and is using msaccess2000 thru adodb. Users on diffrent computers can access the database at the same time but once an individual user starts editing other users must not be able to modify the table at the same time.

My problem is how can i know that the current table is being modified by a user so i could lock it and warn other users from modifying it. Please help me what code will i write.

Thankz in advance