duplicate values for primary key

all of the sudden my table's autonumber field is using numbers that have
already been defined. therefore, I am getting an error message to change the
data in field, remove the index, redefine the index to permit duplicate
entries. this table has relationships with other tables - any of the above it
will not let me do.

why would the autonumber start reusing numbers (there are only 195 records
in this table currently)? I saw something about restarting the numbering by
appending the table to a new temp table, but got lost in the instructions, I
guess, since it didn't work.

See:
Fixing AutoNumbers when Access assigns negatives or duplicates
at:
http://allenbrowne.com/ser-40.html
for an explanation of the causes and solutions.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frank" wrote in message
...
all of the sudden my table's autonumber field is using numbers that have
already been defined. therefore, I am getting an error message to change
the
data in field, remove the index, redefine the index to permit duplicate
entries. this table has relationships with other tables - any of the above
it
will not let me do.

why would the autonumber start reusing numbers (there are only 195 records
in this table currently)? I saw something about restarting the numbering
by
appending the table to a new temp table, but got lost in the instructions,
I
guess, since it didn't work.