Strange Table Performance/Response

[MarkA70]

Solved: Strange Table Performance/Response

MS Access 2010. I have a VERY simple table, no look ups or whatever. Primary Index is an integer, increment field. There are no other indexes in the table. I had not had to use it for a time, today when an attempt to enter a new record via form directly on the table, the Primary Index gets set to an Index value already contained in the table. Of course the result is the inability to save the record. I have never seen this before, I cannot understand what would have caused this response, especially in Table View, with no form events or other to cause something to be amiss. Is there away out of this dilemma, I REALLY need this table?

 

[gemma-the-husky]

do you mean its an autonumber?

it can go wrong occasionally

google "reseeding" an autonumber.

 

[GinaWhipp]

Have a look at...
http://allenbrowne.com/ser-40.html

 

[MarkA70]

So here is what I did. Created a matching table with different name, with the Primary Key being an Auto Numbered but Random field. Created an Append Query that Appended everything but the Original Tables Primary Key. Then swapped names on the Tables so that New Table became Old Table and vice versa, everything is back on track.

However, another one of those 3 hour ordeals that causes you to question your sanity. Thanks so much for the articles so I know that I am not crazy, or can still do a table. I would have posted the question earlier but I had never seen or heard of this happening!