How change start autonumber ???

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

Guest

How do I set the starting autonumber to other than 1 ???

Does it matter if the table has already had records added so long as they have been deleted?
i.e. if the table is empty is it possible even though it had had records added then deleted?

I looked in Help but its very vague.
 
How do I set the starting autonumber to other than 1 ??
Click to expand...

append a record with the AN field set to one less than the one you want:

INSERT INTO MyTable (MyAutonumber)
VALUES (99);

you can then delete it again

DELETE FROM MyTable WHERE MyAutonumber = 99;
Does it matter if the table has already had records added so long as
they have been deleted?
Click to expand...

If the AN counter is higher than where you want to start, you'll have to
compact the database to reset it to zero, then insert the dummy record.

**************** BUT ******************

"If you care what value an autonumber has, then
you probably shouldn't be using an autonumber..."


Hope that helps


Tim F
 
Back
Top