Change the starting value of an AutoNumber field

[JB]

Hello
when I appended some data into my main table, the autonumber jumped from
around 544 to 26300.
There are only 276 rows in the table.
The most rows I've deleted from the table would be maybe 200, when I was
designing and testing the table, certainly not 25000.

All I could find in Help was "Change the starting value of an AutoNumber
field". I followed the instructions but that didn't work.

Any suggestions on what I can do to lower the Autonumber?
The table is related to 2 other tables.

Thank you
Jen

 

[tina]

the Autonumber should be used to provide a primary key for a table, and for
nothing else. and it should never have meaning in the "real" world, or ever
be seen by the user, whether in its' own table or in any table in which it's
used as a foreign key. given the above, what's the reason you're concerned
about the values assigned by the Autonumber?

hth

 

[JB]

I know you do have a point. It stems from my need to tidy. But I should
leave it alone.
Jen

 

[tina]

well, not so much "should", hon, but...you could spend hours or days fussing
with it, if you wanted to, to fix the existing records *right now*. but it's
likely to just happen again as more records are added to the table, so might
as well invest your valuable time and energy in something that will actually
improve your database.