How do I unlock a locked record in an Access database?

[Guest]

I use Access in a multiuser environment. A record in a table has locked. I
can not delete the record. Queries based upon this table will not function,
as there is a locked record in the table. How do I unlock this record?
I'm using Acess 2000.
Thanks for any help available

 

[TC]

I use Access in a multiuser environment. A record in a table has locked. I
can not delete the record. Queries based upon this table will not function,
as there is a locked record in the table. How do I unlock this record?
I'm using Acess 2000.
Thanks for any help available

What makes you say that the record is locked?

In what way do the queries "not function"?

What happens when you try to delete the "locked" record?

TC (MVP Access)
http://tc2.atspace.com

 

[Allen Browne]

The simplest solution is to create another table with all the other records.

The crucial part is *not* to refer to the bad record during that process.
Details in the 3rd symptom in this article:
Recovering from corruption
at:
http://allenbrowne.com/ser-47.html