NetworkIssue

Existing functionality:

user A enters the form first, makes some changes,

after sometime user B enters the same form. Now

user A clicks "Save", and is still in the form.

now if user B has made some changes and clicks

"save", his changes should be reflected, and it

should be saved.


Desired Functionality:

If user A gets into the form first, then as long

as he is in the form, only his changes are final,

if user B enters the form after user A, and clicks

"save", his changes should not be saved( as long as
A is in the same form)

some message should appear to B indicating that someone

else is using the same form and has a higher
priority over B.

NOTE: DATABASE IS MYSQL, FRONT END IS VB6.

You could set up an Edit table in your db, and as soon as someone edits a record, write some information back regarding what record it is and who has it. When someone else tries to edit a record, first do a check to see if it is the same record.

If it is, then display a message, if it isn't then let them go ahead, after logging their edit information.

When they are done with the save, you have to release the record by removing the edit information.