All I have been able to do is tell the user that what they were trying to do failed and let one of the administartors know. The admin people get everyone off and the user has to try again - not very clean, but I haven't come up with a work around.
Steve Vellella
On Tue, 20 Jul 2004 11:05:08 -0700 (PDT) Lawrence Lustig <[EMAIL PROTECTED]> wrote:
I've noticed that I seem to be getting phantom table locks -- tables are locked (with an (L) in the LIST TABLES ouput) even when no one is in the table. I think these locks may be left around by forms.
Is anyone experiencing anything similar?
Right now, I have a table locked in an R:Base database being accessed by many users. The user who was editing the table (actually two tables, header and details) has exited R:Base, but the table lock is persisting. The other users are DOS users and their code never even looks at the table in question.
I need to run an alter command against the table in question to add a column, but obviously the alter command fails because the table appears to be locked. -- Larry
