I've done this in Access 97.
1.)Create a temporary table with just one field, a Number
field; set its FieldSize property to Long Integer and give
it the same name as the AutoNumber field in the table
whose value you want to change.
2.)In Datasheet view, enter a value in the Number field of
the temporary table that is 1 less than the starting value
you want for the AutoNumber field. For example, if you
want the AutoNumber field to start at 100, enter 99 in the
Number field.
3.)Create and run an append query to append the temporary
table to the table whose AutoNumber value you want to
change.
Note: If your original table has a primary key, you must
temporarily remove the primary key before running the
append query. Also, if your original table contains fields
that have the Required property set to Yes, the Indexed
property set to Yes (No Duplicates), or field and/or
record ValidationRule property settings that prevent Null
entries in fields, you must temporarily disable these
settings.
4.)Delete the temporary table.
5.)Delete the record added by the append query.
6.)If you had to disable property settings in step 3,
return them to their original settings.
NOTE: I located the above steps through the Office
Assistant. Phrase your question to the assistant as "How
do I change the starting value of an autonumber field?"
-----Original Message-----
In a ticket-system I have created for my school, I have
to register some data. While working on the database, I
used some test-data, and these are connected to
autonumbers. The users are now going to use the database,
and they need to register the real datas; they want the
numbers to start at 1, 2, etc... Do I have to make the
whole database over again, or is there any way to reset
the autonumbers?
