Locked Record

[cainemart]

I have a record that is locked and it gives me a message that this record is locked by another user. There isn't another user in the database! Does anyone out there have any suggestions on how to unlock a record that is locked?

Thanks,
CM

 

[TrojanRabbit]

Sounds like you might be having a problem I have sometimes. The lock is in <dbname>.ldb. Sometimes, it won't remove a lock when nobody is in the db. I have to have the network admin delete the .ldb for me.

 

[cainemart]

TrojanRabbit,

Yeah I checked that but that isn't the problem. It won't even show the ldb. This is why I posted the question. I checked the site and people said the same thing but no one gave a final answer if this wasn't the problem.

 

[jayde]

I got this same message last month. It only seemed to be happening to one table. I exported the table data in ascii delimted format created a new table shell and imported the ascii file to populate it. That fixed my problem. The offending table in that case was in a SQL 7 backend. Hope this helps...

Jayde