Built in record locking not enough

[daneharnett]

Hi everyone,
ive found that the builtin locking mechanisms are enough for what i want to do.
I can explain why but can we just accept that i dont want to use them.
Id like to implement my own:
Ive thought to add a "IsLocked" field to the table that i want to use locking with, then wen the record is loaded the form checks with the "IsLocked" is true if it is then all the controls are locked down.. if not then it is set to true and the controls are opened...

Any ideas on how i can implement this?

thanks
Dane

 

[KenReay]

Hi

Implementing it is not difficult, but the implications are !

You will inevitably end up with records marked as locked, which are not really locked, due to hardware / software crashes, users rebooting PC's etc

Take a tip - do not bother

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK