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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Jerry said:
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
Click to expand...

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
 
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
 
Back
Top