Error: Duplicate numbers in index, primary key or relationship

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.
 
A

Arvin Meyer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate values in the index, primary key, or relationship messag 2
"Duplicate values in the index, primary key, or relationship" 2
error message - duplicate values in index, primary key, or relatio 1
Duplicate Values in the index, primary key or relationship 3
Retain old AutoNumbers in new table 1
Duplicate Values in the index, primary key or relationship 4
duplicate values for primary key 1
duplicate value error message - new issue 1

Top