Basically, when you're using AutoNumber for your table, you are implicitly creating a dummy primary key for your table without counting on further modification of this field  and you haven't any concern about the values. If you need to manipulate your key values (update or reuse them), then you must go for manual code generation through your program. It always recommendable.