I used a SQL Statement to insert a record into an existing table. When I added a the new record, I set the Keyfield (which is defined as AutoNumber) to -1. I did this because I need to be able to trask this in my customers database. The user can also add records to this table.
Once I add this record, my next value for the autonumber is 0. Knowing this, I have two questions:
1. Is there anyway to do what I did and NOT have it reset the autonumber?
2. Is there anyway from code to reset the next value once it's messed up. I know I can open the database and copy/paste the table (or import it) to reset it.