Gmoney
asked on
How to determine if a LAN user is editing the current record
Is there a way to tell if myself and another user are editing the same record across a LAN? I am using the Data control.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the points, and glad to have been of help.
Bye
Rem
Bye
Rem
Yes there are different ways depending on your configuration: OS, Database, ....
If your Database supports locking single records like
SQL-Server 7.0 or higher for example you haven't much to do.
If your Database doesn't support single record locking.
Access for example locks 2K pages an cannot lock single records. So you will get a conflict although the 2 users are editing different records if the pages have an intersection.
An approach would be having an extra locking table where you store the current lockings. However you have to do some clean-up process if you find 'too' old lockings.
They could have been remained after system crash or abnormal program termination.
V.K.