Table locked after inserting a record with autonumber field value

[MrMode]

I have inserted a record into a table. The record included a value in the autonumber key field that was less than the next value.

This has locked the table. Even after closing the machine that did the transaction, which allegedly has locked the table, I cannot unlock the table. I cannot compress and reindex.

I have inserted a new record so that the autonumber is incrementing correctly again.

Is there anyway to unlock this table?

 

[LaurieHamlin]

I've never seen this happen, but I would try making a copy of the table and writing code to delete the record. If that works you can use code to get the record data from the copy and re-enter it into the original table with a correct autonumber. Let us know.

 

[MrMode]

OK, will do. Thanks