Error: Duplicate numbers in index, primary key or relationship

  • Thread starter Thread starter Roxann
  • Start date Start date
R

Roxann

My database lets me add one new record, then it jumps
AutoNumbers (for example from 24 to 30) and gives me an
error that the requested changes would create duplicate
numbers and it does not allow the addition.

I think I caused this problem when I manually deleted
unneeded records in the table.

I would like to start over with this database, but reset
AutoNumbers and remove all data. Would this would fix my
problem? If so, how can I do this? I can create a new
database based on the old, but the AutoNumbers do not
reset. Instead, they continue on and the problem
continues.

If this would not fix the error, what do I need to do?

Thanks very much for any help.
 
If you deleted all the records and then compacted the database it may fix
your problem by resetting the autonumbers. There is a bug in the Access 2000
format that caused the bug that you are seeing now. By applying the current
service pack (SP8), you'll ensure that it won't happen again.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top