id key start with 22?

  • Thread starter Thread starter Guest
  • Start date Start date
Is this a question?

Please post full sentences and explain what it is you are trying to
accomplish.
 
When I start a new database the autonumber for a primary Key ID start with
number 22, and I'll like to know how can I do to start with the number 1.

Thank you.
 
Autonumbers are one way of assigning a unique value to each record. You
should not try to use autonumber as any kind of "real" value. If you want to
assign incrementing numbers to invoices or something like that there are ways
of doing so, but autonumber is not among those ways. Autonumber is for
Access to use. There's usually no reason for you to even look at it once the
database is up and running.
 
Hi,

Yes, autonumber are only used if you need a uniqie number (ie. id key) and
od not want to have write code to create one yourself. It will always start
at 1, but since yours started at 22, you must've already had one and had
those records deleted. Autonumber fields wil never go backward to previously
deleted record.

For example, record #22 had a autonumber of 22, and it was later deleted.
That autonumber of 22 will never be used again even though it if available.

Hope that helps

Frank Stepanski
 
Back
Top