Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
autonumber is not unique 1
- Thread starter mrMika
- Start date
-
1
- #2
Directly from the source BUG: You may receive an error message when you try to insert a new record in a table that contains an Autonumber field in Access 2003
Roy-Vidar
Roy-Vidar
- Thread starter
- #3
Yes, ACC2000: AutoNumber Field Duplicates Previous Values After You Compact and Repair a Database, but I like pasting the 2003 KB, cause of the additional workaround info.
Roy-Vidar
Roy-Vidar
- Thread starter
- #6
thank you both for your input.
The strange thing about this is that the number that is being generated is far from the being the highest. For example if there were 100 records the autonumber might generate 25 or 50 instead of 101.
Somehow there seems to be some sort of corruption in the db that none of my old tricks have been able to resolve.
I have tried Roys solution and it does work for a time but but the problem comes back later on.
The strange thing about this is that the number that is being generated is far from the being the highest. For example if there were 100 records the autonumber might generate 25 or 50 instead of 101.
Somehow there seems to be some sort of corruption in the db that none of my old tricks have been able to resolve.
I have tried Roys solution and it does work for a time but but the problem comes back later on.
- Status
