Board index » off-topic » how to prevent transaction from locking my table
how to prevent transaction from locking my table
2004-08-11 05:11:36 PM
I'm using BCB5 with MSACCESS and BDE.
I have an application that starts a transaction. inserts a record in a table
and allows the user to alter fields in the new record.
The new record gets commited when the user clicks on the save button or is
erased when the user clicks on the Close button on the form.
My problem is that the moment the user is busy with the form a lock is
created on the table and none of my other users can access that particular
form or table!! Is this the way a transaction is supposed to work? How can I
overcome this problem because more that one person must be able to work on
that particular table and form.