Hi,
Using Access2000 I have an ID field, an autonumber field, that for some unknown reason went from around 3,000 to 453,054,334 as I tried to append 1200 rows to my table. even if I delete the 1200 rows, the autonumber internal counter is incremented so the next try starts at (453,054,334 +1200).
In the access help file there is a method to store a number to the autonumber field, and it worked for one record, but when I tried my append query, the autonumber was back up there in the stratusphere. I concatenate those ID fields to make a key for another purpose. Think of it as he-ID|she-ID=couple-ID. So you can see why it would be impractical for me to concatenate 2 9-digit numbers!
How can I reset the number for the NEXT records, retaining the ID numbers for rows that are already in the table?
Any help will be GREATLY appreciated.
Edited by Routhg