Unanswered: reindex primary key after append query
I performed an append action query on a table to have the records from one table append to a new table. The new table was empty. The primary key (ID) was auto-increment. There were 563 records appended to a empty table.
After the append query, the first record has an ID of 564. For some reason auto-increment started at 564.
Is there another query of tool within ACCESS to reindex the primary key ?
MOwen and 24jedi are right.... you'd have to drop the original index and repopulate the table to re-index it. This is because in most cases people want to keep the original index numbers intact.... it's a feature that savaed a lot of trouble here a few times...