unlock records

[TAMch]

My application has several user with diffrent access, edit or browse.

They coud run big calculation, which reads and produce up to 200'000 records per calcuation.

My main problem is how to unlock records via script. A rollback for the script is quite a big job, preventing an user from editing a record is also quite tough, specially if they use different timezones.

Like lunch effect, causes me a problem and taking down the database is also not solution.

I was thinking to creating time loops with a commit, to edit records, but I don't like the solution. (less user friendly).

Any Solutions?

[Vaughan]

How are the records being locked in the first place?