Another Autonumber Q

[Guest]

I have appended records from one table to another one. THe original table had
an autonumber field, and it seemed fine with the new data.

However, now when I try to add a new record to the table, it assigns an
autonumber that is already taken. For example, the next record in the
sequence should be 3005, but the automunber field fills with 563, then the
program tells me I can't save the record because it would create a duplicate
value.

I don't want to renumber the whole table because the autonumber field is
also a primary field linking the records to other tables.

WHat happened? What should I do? Thanks! (I'm using Access 2003.)

 

[Guest]

Try and compact the database, mybe it will start the count from the last
number.
Back up you DB before running compact