Restart numbering auto number primary key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

Does someone could tell me how to restart the numbering plan of the table primary key ? It using a big number.
 
Why? Access Autonumbers are intended for use as a unique row identifier.
Why does it matter what value they have?
 
Well, you could copy your table then delete all the records from the new
table copy, Run an append query to add all the records from the original
table into the new table. That should reset the autonumber starting place
to 1. HOWEVER, the value of the autonumber field is largely irrelevant. It
just provides a unique key and should NOT be used as a record numbering
system except for internal database use (i.e. relationships to long interger
foreign keys in other tables). Most applications don't even display the
autonumber value to users.
-Ed

THILMANT Serge said:
Hi all,

Does someone could tell me how to restart the numbering plan of the table
Click to expand...
primary key ? It using a big number.
 
Back
Top