Windows 7 32bit 
Access 2010 32bit
I have a client list created in Acces. It is AutoNumbered in the first field labeled ID. It is set to AutoNumber, Long Interger, Increment, No Indexing. I have 3119 entries. It starts with number 1 and ends with number 3015. However, numbers 2808 through 2911 are duplicated - I have 2 of each. When I try to add a new entry, it numbers it next after the dulicates (2912). Is there a way to correct this so that I have no duplicates and it starts numbering correctly? I am not very Access literate - so please be very specific! Thank you!
Reply With Quote
