AutoNumber Duplicates

[marebear]

My problem is that when I enter new people into our company database (that has about 3,600 people although they are assigned numbers up to 5,000), the autonumber assigns them a number that is already used by another person. I get an error message and the only way to stop the messages is to exit out of the table. The set up appears to be correct-indexed without duplicates. I'm sure it's something simple that I'm looking over.

 

[mdemarte]

correcting auto-number problem

My guess is that wherever Access tracks the auto-number, the setting is wrong. Usually, you want the next auto-number assigned. To follow your example, 5001. To fix it, make a copy of your table, structure ownly. Change your auto-number field in your copy to a long integer. Now, add one record to your copy file with the correct number. Finally, append it to the original. You can then go into your table and edit the record. The next time, your auto-number should be fixed.

Oh, you should probably delete the copy of the table (just to keep things clean).