Thanks,
As soon as I can (probably midnight) I will shut the database down and
do the maintenance. Still wondering how the lock was placed to begin
with. I suppose an Insert record puts a temporary lock and for some
reason, one did not get released.
Bob Thompson
LaPorte, IN
219-363-7441
Sent from my iPod
On Mar 10, 2011, at 12:09 PM, Lawrence Lustig <[email protected]>
wrote:
<<
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.
>>
Yes, there are circumstances in which locks get set and the only
solution is to have all users disconnect and then have a single user
connect the database with no one else in it. I don't know the chain
of circumstances necessary to reproduce it (may require simultaneous
DOS and Windows access, for all I know), but do see it happen fairly
frequently.
The listview should not be setting a lock by itself.
--
Larry
