The form is not based on any table. It is a variable form. The
variable list view object in the form is based on a table and this
table is where I am seeing the row lock.
The variable lookup list view is the only object in the database that
is linked to this table. Some eeps do insert rows, but nothing would
set a continuous lock to my understanding.
If the list view does not set a lock, can a lock somehow get "stuck"
and not release? This table shows a row lock 100% of the time, but
the only object accessing it is the list view.
Thanks,
Bob Thompson
LaPorte, IN
219-363-7441
Sent from my iPod
On Mar 10, 2011, at 11:33 AM, Lawrence Lustig <[email protected]>
wrote:
<<
Just needing to understand the logic of the variable lookup list
view concerning Locks.
>>
The trick is that you should NOT attach the form to the table used
by the listview. If the form is based entirely on the listview and
doesn't directly display data, it can be a variable (table-less)
form, or you can base it on a one-row dummy table. The table from
which the list view draws its data should not be the driving table.
If you do this, the table from which the listview draws its data
will not get locked.
--
Larry
