hey guys, i read that C&R for access does this
" Reset the next available number for Autonumber (or “identity”) fields so the next available number is one higher than the current highest value in the table.
if i have a table with an autonumber and i fill some records, and then delete ALL the records, yes after i C&R and add a new record in the empty table, it starts from 1.
however if i have 10 records and then i add 5 more (so now my autonumber for the last record is 15), and then i delete the last 5 records so that autonumber for for the last record now is 10, when i C&R and then add a new record, the autonumber for the new record is 16 not 11.
is something wrong? i tried this in an empty Access 2007 mdb and it's always reproducible. so how come C&R doesn't lower a non-empty table's autonumber field? thanks guys! = )