FreeLocks (Please!)

by Murray Cox - GUI Computing

A little known statement in Visual Basic's arsenal is FreeLocks.

The VB manual describes it as :
Use the FreeLocks statement in multi-user, multi-tasking environments where there is not enough time for background processing to keep all records current in your recordset. Normally, read locks are removed and data in local Dynaset objects is updated only when no other actions (including mouse moves) are occurring. If data processing is so intense that normal background management of locks is unable to keep up, then you should periodically use FreeLocks to allow the processing that would ordinarily occur in the background.

I recently encountered just such a situation that required the use of FreeLocks.

Written by: Murray Cox
Oct 95