Hi!

Together with locking record put also a date/time of the record added in the field. If this time is too late (for example 10 minutes), automatically unclock that record because no any user have rights to lock records longer.

>Hello Fellows,
>
>I'm implementing the multiuser enviroment using SQL Server as database.
>
>For the lock of the records im not using the database locking, i create a table with the fields ( key1, key2, key3, key4, key5, key6, tablename ), and there i insert (lock) or delete(unlock) the records from the diferrent tables.
>
>Now, i got a big question...What about if the user dont close the aplication and just shut off the machine...how can i unlock the record on the table that the user were using?
>
>
>Think about it and help me out
>
>Ricardo Martins