I have experienced the same problem, just yesterday. It looks like the only thing that you can do is to disconnect all users from the database. I am still waiting for anybody to tell me how to unlock the table without having to disconnect all users from database.
Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Tuesday, July 20, 2004 2:05 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Extra table locks 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
