Reset autonumber to 1066

  • Thread starter Thread starter james read
  • Start date Start date
J

james read

Is it possible to reset the value of the an autonumber
field to follow a logical sequence (I ran an append query
and then had to delete 1300 recs)? If so, How?
 
Take a look at these two articles - they should address what you are trying
to accomplish.

209696 ACC2000: How to Use an Append Query to Set Initial Value of an
http://support.microsoft.com/?id=209696

812718 Reset an AutoNumber Field Value in Access
http://support.microsoft.com/?id=812718

--
Kristyn Wagoner
Microsoft PSS

Please do not reply directly to this alias. This alias is for newsgroup
purposes only.

This posting is provided "AS IS" with no warranties, and confers no rights.
 
If you felt the need of resetting AutoNumber field to particular
value/sequence, then you are misusing AutoNumber field: it is not meant for
that. The only purpose to use AutoNumber is to get a UNIQUE value for that
field in a table. If you need a numbered field with its value in sequence,
you have to define your own field and implement your own algorithm to
maintain it.
 
Back
Top