Record lock for editing

[IpeXeuS]

Hi there,

I've one problem with multiuser environment application. Ok, theres about 5 users occasionally using my application and what I try to complish here is that when user opens specific record for editing, then it's locked from other users and they will receive a message about it. If you know guys any tips what's easiest way to do this with some vba code, please I would approciated that very much. Thanks for advantage...

 

[Zigzag]

Locked records

I find the best way to do this is by adding another field "lockinfo"
When a user opens the form the "lockinfo" is populated with Computer name or login name or the time or a combination of all its upto you.

If another user then opens this record it check on the "logininfo" and if its not null or 0 then a popup tells the user that this records is being edited by "computer name" etc etc.

When the first user closes the form the "lockinfo" is set to 0 or null.

If you need me to elaberate on this further just let me know.

Garry

 

[stopher]

Check out the RecordLocks property for the form. Setting it to "Edited record" will lock the record when a user starts editing the record. A locked symbol will be displayed to other users who try to edit the record while the first user is editing it.

Chris

 

[IpeXeuS]

Ok, thanks for your tips. But I don't have any popup forms, cause everything is in one form, but theres lot's of subforms init. That message for other users would be great. So, where should I start this process?